API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 8th, 2019
81
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 5.13 KB | None | 0 0
raw download clone embed print report
  1.  Sort  (cost=60053.04..60274.66 rows=88649 width=175) (actual time=589.667..589.668 rows=2 loops=1)
  2.    Sort Key: ((to_char(p.datetime, 'YYYY-MM-DD'::text) || to_char((((date_part('HOUR'::text, p.datetime) + (date_part('minute'::text, p.datetime) / 60::double precision)) + (date_part('second'::text, p.
  3.    Sort Method: quicksort  Memory: 25kB
  4.    CTE ylvc
  5.      ->  Limit  (cost=93.72..93.73 rows=1 width=18) (actual time=0.151..0.152 rows=1 loops=1)
  6.            ->  Unique  (cost=93.72..93.73 rows=2 width=18) (actual time=0.150..0.150 rows=1 loops=1)
  7.                  ->  Sort  (cost=93.72..93.72 rows=2 width=18) (actual time=0.149..0.149 rows=1 loops=1)
  8.                        Sort Key: l.ligo_id
  9.                        Sort Method: quicksort  Memory: 26kB
  10.                        ->  Nested Loop  (cost=0.56..93.71 rows=2 width=18) (actual time=0.024..0.076 rows=24 loops=1)
  11.                              Join Filter: (l.t_id = ntab.id)
  12.                              ->  Seq Scan on tables ntab  (cost=0.00..1.11 rows=1 width=4) (actual time=0.007..0.008 rows=1 loops=1)
  13.                                    Filter: (name = 'transients'::text)
  14.                                    Rows Removed by Filter: 8
  15.                              ->  Index Scan using ligo__trans_observation_o_id_idx on ligo__trans_observation l  (cost=0.56..92.32 rows=22 width=20) (actual time=0.014..0.058 rows=24 loops=1)
  16.                                    Index Cond: (o_id = 8815939)
  17.    ->  Hash Left Join  (cost=32718.17..45096.72 rows=88649 width=175) (actual time=572.150..589.640 rows=2 loops=1)
  18.          Hash Cond: (s.proc_id = p.id)
  19.          ->  Nested Loop  (cost=0.43..60.16 rows=88649 width=137) (actual time=0.272..0.297 rows=2 loops=1)
  20.                ->  Nested Loop Left Join  (cost=0.43..8.49 rows=1 width=88) (actual time=0.196..0.202 rows=1 loops=1)
  21.                      Join Filter: (t.id = ylvc.o_id)
  22.                      ->  Index Scan using transients_pkey on transients t  (cost=0.43..8.45 rows=1 width=48) (actual time=0.039..0.043 rows=1 loops=1)
  23.                            Index Cond: (id = 8815939)
  24.                      ->  CTE Scan on ylvc  (cost=0.00..0.02 rows=1 width=40) (actual time=0.154..0.156 rows=1 loops=1)
  25.                            Filter: (o_id = 8815939)
  26.                ->  Append  (cost=0.00..51.60 rows=7 width=49) (actual time=0.072..0.087 rows=2 loops=1)
  27.                      ->  Seq Scan on stars s  (cost=0.00..0.00 rows=1 width=49) (actual time=0.001..0.001 rows=0 loops=1)
  28.                            Filter: ((t.s_id1 = id) OR (t.s_id2 = id))
  29.                      ->  Bitmap Heap Scan on stars_1 s_1  (cost=9.18..17.20 rows=2 width=49) (actual time=0.020..0.020 rows=0 loops=1)
  30.                            Recheck Cond: ((t.s_id1 = id) OR (t.s_id2 = id))
  31.                            ->  BitmapOr  (cost=9.18..9.18 rows=2 width=0) (actual time=0.016..0.016 rows=0 loops=1)
  32.                                  ->  Bitmap Index Scan on stars1__id_index  (cost=0.00..4.59 rows=1 width=0) (actual time=0.012..0.012 rows=0 loops=1)
  33.                                        Index Cond: (t.s_id1 = id)
  34.                                  ->  Bitmap Index Scan on stars1__id_index  (cost=0.00..4.59 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=1)
  35.                                        Index Cond: (t.s_id2 = id)
  36.                      ->  Bitmap Heap Scan on stars_0000400000 s_2  (cost=9.17..17.20 rows=2 width=49) (actual time=0.013..0.013 rows=0 loops=1)
  37.                            Recheck Cond: ((t.s_id1 = id) OR (t.s_id2 = id))
  38.                            ->  BitmapOr  (cost=9.17..9.17 rows=2 width=0) (actual time=0.011..0.011 rows=0 loops=1)
  39.                                  ->  Bitmap Index Scan on stars_0000400000_pkey  (cost=0.00..4.58 rows=1 width=0) (actual time=0.009..0.009 rows=0 loops=1)
  40.                                        Index Cond: (t.s_id1 = id)
  41.                                  ->  Bitmap Index Scan on stars_0000400000_pkey  (cost=0.00..4.58 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)
  42.                                        Index Cond: (t.s_id2 = id)
  43.                      ->  Bitmap Heap Scan on stars_0000600000 s_3  (cost=9.17..17.20 rows=2 width=49) (actual time=0.030..0.043 rows=2 loops=1)
  44.                            Recheck Cond: ((t.s_id1 = id) OR (t.s_id2 = id))
  45.                            ->  BitmapOr  (cost=9.17..9.17 rows=2 width=0) (actual time=0.024..0.024 rows=0 loops=1)
  46.                                  ->  Bitmap Index Scan on stars_0000600000_pkey  (cost=0.00..4.58 rows=1 width=0) (actual time=0.010..0.010 rows=1 loops=1)
  47.                                        Index Cond: (t.s_id1 = id)
  48.                                  ->  Bitmap Index Scan on stars_0000600000_pkey  (cost=0.00..4.58 rows=1 width=0) (actual time=0.013..0.013 rows=1 loops=1)
  49.                                        Index Cond: (t.s_id2 = id)
  50.          ->  Hash  (cost=21885.88..21885.88 rows=508788 width=42) (actual time=552.265..552.265 rows=518725 loops=1)
  51.                Buckets: 16384  Batches: 8  Memory Usage: 4825kB
  52.                ->  Seq Scan on proc_data p  (cost=0.00..21885.88 rows=508788 width=42) (actual time=0.006..270.133 rows=518725 loops=1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!