#	exclusive	inclusive	rows x	node
1.	0.000	0.000	↓ 0.0	→ Limit (cost=3459.56..3939.85 rows=40 width=1188) (actual time=.. rows= loops=)
2.				CTE send_push
3.	0.000	0.000	↓ 0.0	→ Hash Semi Join (cost=3391.82..3450.76 rows=20 width=92) (actual time=.. rows= loops=) Hash Cond: ((public.sendpush."UUID")::text = (public.pushdevices."UUID")::text)
4.	0.000	0.000	↓ 0.0	→ Seq Scan on sendpush (cost=0.00..54.41 rows=1641 width=92) (actual time=.. rows= loops=)
5.	0.000	0.000	↓ 0.0	→ Hash (cost=3391.74..3391.74 rows=6 width=82) (actual time=.. rows= loops=)
6.	0.000	0.000	↓ 0.0	→ Hash Join (cost=3331.12..3391.74 rows=6 width=82) (actual time=.. rows= loops=) Hash Cond: ((public.sendpush."UUID")::text = (public.pushdevices."UUID")::text)
7.	0.000	0.000	↓ 0.0	→ Seq Scan on sendpush (cost=0.00..54.41 rows=1641 width=41) (actual time=.. rows= loops=)
8.	0.000	0.000	↓ 0.0	→ Hash (cost=3314.95..3314.95 rows=1294 width=41) (actual time=.. rows= loops=)
9.	0.000	0.000	↓ 0.0	→ Bitmap Heap Scan on pushdevices (cost=30.32..3314.95 rows=1294 width=41) (actual time=.. rows= loops=) Recheck Cond: ("Offset" = 77::numeric)
10.	0.000	0.000	↓ 0.0	→ Bitmap Index Scan on "offset" (cost=0.00..30.00 rows=1294 width=0) (actual time=.. rows= loops=) Index Cond: ("Offset" = 77::numeric)
11.	0.000	0.000	↓ 0.0	→ Nested Loop Left Join (cost=8.80..489.09 rows=40 width=1188) (actual time=.. rows= loops=) Join Filter: (((public.pushdevices."UUID")::text = (send_push."UUID")::text) OR ((public.pushdevices."UUID")::text = (sync."Second")::text))
12.	0.000	0.000	↓ 0.0	→ Nested Loop Left Join (cost=0.00..154.08 rows=20 width=1034) (actual time=.. rows= loops=)
13.	0.000	0.000	↓ 0.0	→ CTE Scan on send_push (cost=0.00..0.40 rows=20 width=952) (actual time=.. rows= loops=)
14.	0.000	0.000	↓ 0.0	→ Index Scan using sync_copy_pkey on sync (cost=0.00..7.67 rows=1 width=82) (actual time=.. rows= loops=) Index Cond: ((send_push."UUID")::text = ("First")::text)
15.	0.000	0.000	↓ 0.0	→ Bitmap Heap Scan on pushdevices (cost=8.80..16.72 rows=2 width=154) (actual time=.. rows= loops=) Recheck Cond: ((("UUID")::text = (send_push."UUID")::text) OR (("UUID")::text = (sync."Second")::text))
16.	0.000	0.000	↓ 0.0	→ BitmapOr (cost=8.80..8.80 rows=2 width=0) (actual time=.. rows= loops=)
17.	0.000	0.000	↓ 0.0	→ Bitmap Index Scan on pushdevices_pkey (cost=0.00..4.40 rows=1 width=0) (actual time=.. rows= loops=) Index Cond: (("UUID")::text = (send_push."UUID")::text)
18.	0.000	0.000	↓ 0.0	→ Bitmap Index Scan on pushdevices_pkey (cost=0.00..4.40 rows=1 width=0) (actual time=.. rows= loops=) Index Cond: (("UUID")::text = (sync."Second")::text)

Limit  (cost=3459.56..3939.85 rows=40 width=1188)
  CTE send_push
    ->  Hash Semi Join  (cost=3391.82..3450.76 rows=20 width=92)
          Hash Cond: ((public.sendpush."UUID")::text = (public.pushdevices."UUID")::text)
          ->  Seq Scan on sendpush  (cost=0.00..54.41 rows=1641 width=92)
          ->  Hash  (cost=3391.74..3391.74 rows=6 width=82)
                ->  Hash Join  (cost=3331.12..3391.74 rows=6 width=82)
                      Hash Cond: ((public.sendpush."UUID")::text = (public.pushdevices."UUID")::text)
                      ->  Seq Scan on sendpush  (cost=0.00..54.41 rows=1641 width=41)
                      ->  Hash  (cost=3314.95..3314.95 rows=1294 width=41)
                            ->  Bitmap Heap Scan on pushdevices  (cost=30.32..3314.95 rows=1294 width=41)
                                  Recheck Cond: ("Offset" = 77::numeric)
                                  ->  Bitmap Index Scan on "offset"  (cost=0.00..30.00 rows=1294 width=0)
                                        Index Cond: ("Offset" = 77::numeric)
  ->  Nested Loop Left Join  (cost=8.80..489.09 rows=40 width=1188)
        Join Filter: (((public.pushdevices."UUID")::text = (send_push."UUID")::text) OR ((public.pushdevices."UUID")::text = (sync."Second")::text))
        ->  Nested Loop Left Join  (cost=0.00..154.08 rows=20 width=1034)
              ->  CTE Scan on send_push  (cost=0.00..0.40 rows=20 width=952)
              ->  Index Scan using sync_copy_pkey on sync  (cost=0.00..7.67 rows=1 width=82)
                    Index Cond: ((send_push."UUID")::text = ("First")::text)
        ->  Bitmap Heap Scan on pushdevices  (cost=8.80..16.72 rows=2 width=154)
              Recheck Cond: ((("UUID")::text = (send_push."UUID")::text) OR (("UUID")::text = (sync."Second")::text))
              ->  BitmapOr  (cost=8.80..8.80 rows=2 width=0)
                    ->  Bitmap Index Scan on pushdevices_pkey  (cost=0.00..4.40 rows=1 width=0)
                          Index Cond: (("UUID")::text = (send_push."UUID")::text)
                    ->  Bitmap Index Scan on pushdevices_pkey  (cost=0.00..4.40 rows=1 width=0)
                          Index Cond: (("UUID")::text = (sync."Second")::text)

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	2	0.000 ms	0.0 %
Bitmap Index Scan	3	0.000 ms	0.0 %
BitmapOr	1	0.000 ms	0.0 %
CTE Scan	1	0.000 ms	0.0 %
Hash	2	0.000 ms	0.0 %
Hash Join	1	0.000 ms	0.0 %
Hash Semi Join	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
Limit	1	0.000 ms	0.0 %
Nested Loop Left Join	2	0.000 ms	0.0 %
Seq Scan	2	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
pushdevices	2	0.000 ms	0.0 %
Bitmap Heap Scan	2	0.000 ms	0.0 %
sendpush	2	0.000 ms	0.0 %
Seq Scan	2	0.000 ms	0.0 %
sync	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: D7E

Colorize:

Columns visibility:

Per node type stats

Per table stats