explain.depesz.com

A tool for finding a real cause for slow queries.

Result: D7E

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops 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)