explain.depesz.com

A tool for finding a real cause for slow queries.

Result: GWC

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.003 3,128.525 ↑ 1.0 1 1

Limit (cost=2,036,257.190..2,036,257.320 rows=1 width=36) (actual time=3,128.524..3,128.525 rows=1 loops=1)

  • Total runtime: 3128.763 ms
2. 0.024 3,128.522 ↑ 25.0 1 1

Subquery Scan on sq3 (cost=2,036,257.190..2,036,260.560 rows=25 width=36) (actual time=3,128.522..3,128.522 rows=1 loops=1)

3. 0.007 3,128.498 ↑ 25.0 1 1

WindowAgg (cost=2,036,257.190..2,036,257.940 rows=25 width=40) (actual time=3,128.498..3,128.498 rows=1 loops=1)

4. 0.019 3,128.491 ↑ 25.0 1 1

Sort (cost=2,036,257.190..2,036,257.250 rows=25 width=40) (actual time=3,128.491..3,128.491 rows=1 loops=1)

  • Sort Key: delta_zulu2.mike, delta_zulu2.juliet_papa
  • Sort Method: quicksort Memory: 26kB
5. 0.110 3,128.472 ↑ 1.5 17 1

WindowAgg (cost=3.340..2,036,256.610 rows=25 width=40) (actual time=3,128.461..3,128.472 rows=17 loops=1)

6. 0.029 3,128.362 ↑ 1.5 17 1

Subquery Scan on sq2 (cost=3.340..2,036,256.300 rows=25 width=40) (actual time=1,066.735..3,128.362 rows=17 loops=1)

7. 0.671 3,128.333 ↑ 1.5 17 1

WindowAgg (cost=3.340..2,036,256.050 rows=25 width=34) (actual time=1,066.734..3,128.333 rows=17 loops=1)

8. 0.084 1,032.324 ↑ 1.5 17 1

Sort (cost=3.340..3.400 rows=25 width=34) (actual time=1,032.304..1,032.324 rows=17 loops=1)

  • Sort Key: ((four.foxtrot_whiskey - (delta_four 5)))
  • Sort Method: quicksort Memory: 26kB
9. 0.170 1,032.240 ↑ 1.5 17 1

Seq Scan on three_five four (cost=0.000..2.760 rows=25 width=34) (actual time=6.349..1,032.240 rows=17 loops=1)

  • Filter: (foxtrot_oscar AND echo)zulu_lima,
  • SubPlan 5k_rank) as total_sent,
10. 1.071 1,032.070 ↑ 1.0 1 17

Aggregate (cost=20,892.390..20,892.400 rows=1 width=4) (actual time=60.710..60.710 rows=1 loops=17)

11. 34.303 1,030.999 ↑ 21.9 165 17

Nested Loop (cost=31.910..20,883.360 rows=3,612 width=4) (actual time=60.300..60.647 rows=165 loops=17)

12. 48.518 55.624 ↓ 2.3 3,460 17

Bitmap Heap Scan on uniform alpha (cost=31.910..2,680.770 rows=1,501 width=4) (actual time=0.595..3.272 rows=3,460 loops=17)

  • Recheck Cond: (oscar = four.oscar)
13. 7.106 7.106 ↓ 2.3 3,460 17

Bitmap Index Scan on whiskey (cost=0.000..31.540 rows=1,501 width=0) (actual time=0.418..0.418 rows=3,460 loops=17)

  • Index Cond: (oscar = four.oscar)
14. 941.072 941.072 ↓ 0.0 0 58,817

Index Scan using quebec on zulu_xray juliet_xray (cost=0.000..11.980 rows=12 width=8) (actual time=0.016..0.016 rows=0 loops=58,817)

  • Index Cond: (delta_hotel = alpha.delta_hotel)
  • Filter: (two >= (papa('six'::text, (zulu_golf() - (four.juliet_sierra)::interval)) + (four.juliet_sierra)::interval))
15.          

SubPlan (forWindowAgg)

16. 1.078 982.828 ↑ 1.0 1 14

Aggregate (cost=20,892.390..20,892.400 rows=1 width=4) (actual time=70.201..70.202 rows=1 loops=14)

17. 53.240 981.750 ↑ 18.1 200 14

Nested Loop (cost=31.910..20,883.360 rows=3,612 width=4) (actual time=69.713..70.125 rows=200 loops=14)

18. 48.258 55.300 ↓ 2.8 4,158 14

Bitmap Heap Scan on uniform alpha (cost=31.910..2,680.770 rows=1,501 width=4) (actual time=0.715..3.950 rows=4,158 loops=14)

  • Recheck Cond: (oscar = four.oscar)
19. 7.042 7.042 ↓ 2.8 4,158 14

Bitmap Index Scan on whiskey (cost=0.000..31.540 rows=1,501 width=0) (actual time=0.503..0.503 rows=4,158 loops=14)

  • Index Cond: (oscar = four.oscar)bravo
20. 873.210 873.210 ↓ 0.0 0 58,214

Index Scan using quebec on zulu_xray juliet_xray (cost=0.000..11.980 rows=12 width=8) (actual time=0.015..0.015 rows=0 loops=58,214)

  • Index Cond: (delta_hotel = alpha.delta_hotel)
  • Filter: (two >= (papa('six'::text, (zulu_golf() - (four.juliet_sierra)::interval)) + (four.juliet_sierra)::interval))
21. 3.411 17.421 ↑ 1.0 1 3

Aggregate (cost=9,386.390..9,386.400 rows=1 width=4) (actual time=5.807..5.807 rows=1 loops=3)

22. 6.869 14.010 ↑ 1.1 3,275 3

Nested Loop (cost=31.660..9,377.370 rows=3,609 width=4) (actual time=0.194..4.670 rows=3,275 loops=3)

23. 0.555 0.648 ↓ 0.0 0 3

Bitmap Heap Scan on uniform alpha (cost=31.660..2,699.290 rows=500 width=4) (actual time=0.181..0.216 rows=0 loops=3)

  • Recheck Cond: (oscar = four.oscar)
  • Filter: (delta_sierra >= (zulu_golf() - ((lima(four.three_tango, 0))::double precision * 'november'::interval)))
24. 0.093 0.093 ↑ 7.5 201 3

Bitmap Index Scan on whiskey (cost=0.000..31.540 rows=1,501 width=0) (actual time=0.031..0.031 rows=201 loops=3)

  • Index Cond: (oscar = four.oscar)
25. 6.493 6.493 ↓ 265.6 9,826 1

Index Scan using quebec on zulu_xray juliet_xray (cost=0.000..12.890 rows=37 width=8) (actual time=0.014..6.493 rows=9,826 loops=1)

  • Index Cond: (delta_hotel = alpha.delta_hotel)
26. 1.071 1,018.266 ↑ 1.0 1 17

Aggregate (cost=20,892.390..20,892.400 rows=1 width=4) (actual time=59.898..59.898 rows=1 loops=17)

27. 79.435 1,017.195 ↑ 21.9 165 17

Nested Loop (cost=31.910..20,883.360 rows=3,612 width=4) (actual time=59.499..59.835 rows=165 loops=17)

28. 48.399 55.505 ↓ 2.3 3,460 17

Bitmap Heap Scan on uniform alpha (cost=31.910..2,680.770 rows=1,501 width=4) (actual time=0.593..3.265 rows=3,460 loops=17)

  • Recheck Cond: (oscar = four.oscar)
29. 7.106 7.106 ↓ 2.3 3,460 17

Bitmap Index Scan on whiskey (cost=0.000..31.540 rows=1,501 width=0) (actual time=0.418..0.418 rows=3,460 loops=17)

  • Index Cond: (oscar = four.oscar)
30. 882.255 882.255 ↓ 0.0 0 58,817

Index Scan using quebec on zulu_xray juliet_xray (cost=0.000..11.980 rows=12 width=8) (actual time=0.015..0.015 rows=0 loops=58,817)

  • Index Cond: (delta_hotel = alpha.delta_hotel)
  • Filter: (two >= (papa('six'::text, (zulu_golf() - (four.juliet_sierra)::interval)) + (four.juliet_sierra)::interval))
31. 3.536 76.823 ↑ 1.0 1 17

Aggregate (cost=9,386.390..9,386.400 rows=1 width=4) (actual time=4.519..4.519 rows=1 loops=17)

32. 7.023 73.287 ↑ 6.2 578 17

Nested Loop (cost=31.660..9,377.370 rows=3,609 width=4) (actual time=3.520..4.311 rows=578 loops=17)

33. 52.564 59.704 ↓ 0.0 0 17

Bitmap Heap Scan on uniform alpha (cost=31.660..2,699.290 rows=500 width=4) (actual time=3.506..3.512 rows=0 loops=17)

  • Recheck Cond: (oscar = four.oscar)
  • Filter: (delta_sierra >= (zulu_golf() - ((lima(four.three_tango, 0))::double precision * 'november'::interval)))
34. 7.140 7.140 ↓ 2.3 3,460 17

Bitmap Index Scan on whiskey (cost=0.000..31.540 rows=1,501 width=0) (actual time=0.420..0.420 rows=3,460 loops=17)

  • Index Cond: (oscar = four.oscar)
35. 6.560 6.560 ↓ 265.6 9,826 1

Index Scan using quebec on zulu_xray juliet_xray (cost=0.000..12.890 rows=37 width=8) (actual time=0.014..6.560 rows=9,826 loops=1)

  • Index Cond: (delta_hotel = alpha.delta_hotel)