explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 8T8

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 200.269 23459.387 ↓ 114657.0 114657 1

Unique (cost=77379.380..77379.520 rows=1 width=271) (actual time=23150.292..23459.387 rows=114657 loops=1)

2. 533.190 23259.118 ↓ 114657.0 114657 1

Sort (cost=77379.380..77379.380 rows=1 width=271) (actual time=23150.289..23259.118 rows=114657 loops=1)

  • Sort Key: romeo_xray.quebec_seven, juliet.sierra_charlie, juliet.quebec_two, juliet.golf_foxtrot_xray, juliet.tango_charlie, alpha_whiskey.two_uniform, seven_november.four_yankee, india_whiskey.two_five, six_whiskey.india_papa, (mike_zulu((charlie_four.india_delta)::text)), mike_hotel.hotel_charlie.zulu_alpha, mike_hotel.hotel_charlie.sierra_kilo_foxtrot, romeo_xray.foxtrot_kilo, romeo_xray.romeo_victor, romeo_xray.kilo_quebec, romeo_xray.three_two, juliet.charlie_alpha, romeo_xray.xray, romeo_xray.romeo_six, three_echo.echo_sierra, three_echo.romeo_tango, golf_romeo.six_lima_zulu, seven_november.romeo_romeo, papa_lima.quebec_seven, papa_lima.romeo_papa, papa_lima.kilo_juliet, papa_lima.november_romeo2, papa_lima.mike_three, papa_lima.six_lima_xray, papa_lima.sierra_kilo_echo, papa_lima.six_delta, papa_lima.papa_zulu, papa_lima.november_uniform, papa_lima.foxtrot_juliet, papa_lima.two_zulu, papa_lima.six_sierra, papa_lima.tango_uniform, papa_lima.sierra_uniform, papa_lima.lima_echo, papa_lima.uniform_zulu, papa_lima.victor, papa_lima.alpha_foxtrot, papa_lima.seven_quebec, papa_lima.kilo_two, papa_lima.sierra_lima, papa_lima.three_zulu, papa_lima.hotel_xray, papa_lima.uniform_november, papa_lima.uniform_delta, papa_lima.hotel_bravo, papa_lima.three_whiskey, papa_lima.bravo_charlie, papa_lima.seven_sierra, papa_lima.lima_sierra
  • Sort Method: external merge Disk: 19192kB
3. 2405.894 22725.928 ↓ 114657.0 114657 1

HashAggregate (cost=77379.350..77379.370 rows=1 width=271) (actual time=22383.609..22725.928 rows=114657 loops=1)

4. 131.662 20320.034 ↓ 123963.0 123963 1

Nested Loop (cost=68010.340..77379.220 rows=1 width=271) (actual time=15454.506..20320.034 rows=123963 loops=1)

5. 202.874 19390.906 ↓ 132911.0 132911 1

Nested Loop (cost=68010.340..77374.910 rows=1 width=279) (actual time=15454.474..19390.906 rows=132911 loops=1)

6. 204.594 18644.780 ↓ 135813.0 135813 1

Nested Loop (cost=68010.340..77370.620 rows=1 width=271) (actual time=15454.434..18644.780 rows=135813 loops=1)

7. 207.032 17896.934 ↓ 135813.0 135813 1

Nested Loop (cost=68010.340..77370.280 rows=1 width=258) (actual time=15454.359..17896.934 rows=135813 loops=1)

8. 1166.798 17177.446 ↓ 128114.0 128114 1

Hash Join (cost=68010.340..77369.980 rows=1 width=258) (actual time=15454.261..17177.446 rows=128114 loops=1)

  • Hash Cond: (seven_november.mike_kilo = golf_romeo.mike_kilo)
9. 471.733 765.258 ↑ 1.0 199579 1

Hash Join (cost=6379.530..14990.740 rows=199579 width=57) (actual time=208.786..765.258 rows=199579 loops=1)

  • Hash Cond: (juliet.quebec_seven = seven_november.mike_kilo)
10. 85.367 85.367 ↑ 1.0 202021 1

Seq Scan on juliet (cost=0.000..4595.210 rows=202021 width=44) (actual time=0.016..85.367 rows=202021 loops=1)

11. 111.487 208.158 ↑ 1.0 199579 1

Hash (cost=3884.790..3884.790 rows=199579 width=13) (actual time=208.158..208.158 rows=199579 loops=1)

12. 96.671 96.671 ↑ 1.0 199579 1

Seq Scan on seven_november (cost=0.000..3884.790 rows=199579 width=13) (actual time=0.026..96.671 rows=199579 loops=1)

13. 325.616 15245.390 ↓ 128114.0 128114 1

Hash (cost=61630.800..61630.800 rows=1 width=217) (actual time=15245.390..15245.390 rows=128114 loops=1)

14. 355.938 14919.774 ↓ 128114.0 128114 1

Nested Loop (cost=37946.220..61630.800 rows=1 width=217) (actual time=1704.229..14919.774 rows=128114 loops=1)

15. 260.907 13677.780 ↓ 295352.0 295352 1

Nested Loop (cost=37946.220..61630.500 rows=1 width=211) (actual time=1703.730..13677.780 rows=295352 loops=1)

16. 324.129 11940.113 ↓ 295352.0 295352 1

Nested Loop (cost=37946.220..61630.200 rows=1 width=211) (actual time=1703.666..11940.113 rows=295352 loops=1)

17. 6641.716 9843.884 ↓ 295350.0 295350 1

Hash Join (cost=37946.220..61629.900 rows=1 width=203) (actual time=1703.534..9843.884 rows=295350 loops=1)

  • Hash Cond: (romeo_xray.quebec_seven = mike_hotel.hotel_charlie.romeo_papa)
18. 1228.297 1584.378 ↓ 1.0 575693 1

Hash Left Join (cost=1402.920..22927.810 rows=575674 width=179) (actual time=85.483..1584.378 rows=575693 loops=1)

  • Hash Cond: (romeo_xray.quebec_seven = papa_lima.romeo_papa)
19. 270.722 270.722 ↑ 1.0 575674 1

Seq Scan on romeo_xray (cost=0.000..13246.740 rows=575674 width=54) (actual time=0.048..270.722 rows=575674 loops=1)

20. 46.417 85.359 ↑ 1.0 36263 1

Hash (cost=949.630..949.630 rows=36263 width=125) (actual time=85.359..85.359 rows=36263 loops=1)

21. 38.942 38.942 ↑ 1.0 36263 1

Seq Scan on papa_lima (cost=0.000..949.630 rows=36263 width=125) (actual time=0.023..38.942 rows=36263 loops=1)

22. 274.554 1617.790 ↓ 295331.0 295331 1

Hash (cost=36543.290..36543.290 rows=1 width=24) (actual time=1617.790..1617.790 rows=295331 loops=1)

23. 614.136 1343.236 ↓ 295331.0 295331 1

Hash Join (cost=23069.580..36543.290 rows=1 width=24) (actual time=640.336..1343.236 rows=295331 loops=1)

  • Hash Cond: ((mike_hotel.hotel_charlie.romeo_papa = mike_hotel.hotel_charlie.romeo_papa) AND (mike_hotel.hotel_charlie.quebec_seven = (alpha_four(mike_hotel.hotel_charlie.quebec_seven))))
24. 89.307 89.307 ↑ 1.0 295592 1

Seq Scan on hotel_charlie (cost=0.000..5344.920 rows=295592 width=24) (actual time=0.018..89.307 rows=295592 loops=1)

25. 158.840 639.793 ↑ 1.0 295331 1

Hash (cost=18635.700..18635.700 rows=295592 width=8) (actual time=639.793..639.793 rows=295331 loops=1)

26. 218.691 480.953 ↑ 1.0 295331 1

GroupAggregate (cost=0.000..15679.780 rows=295592 width=8) (actual time=0.062..480.953 rows=295331 loops=1)

27. 262.262 262.262 ↑ 1.0 295592 1

Index Scan using yankee on hotel_charlie (cost=0.000..10506.920 rows=295592 width=8) (actual time=0.038..262.262 rows=295592 loops=1)

28. 1772.100 1772.100 ↑ 1.0 1 295350

Index Scan using zulu_hotel on delta (cost=0.000..0.290 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=295350)

  • Index Cond: ((delta.romeo_two = romeo_xray.romeo_two) AND (delta.bravo_november = 'zulu_five'::bpchar))
29. 1476.760 1476.760 ↑ 1.0 1 295352

Index Scan using echo_victor on golf_romeo (cost=0.000..0.280 rows=1 width=12) (actual time=0.004..0.005 rows=1 loops=295352)

  • Index Cond: (golf_romeo.quebec_seven = romeo_xray.romeo_two)
30. 886.056 886.056 ↓ 0.0 0 295352

Index Scan using kilo_november on alpha_whiskey (cost=0.000..0.290 rows=1 width=6) (actual time=0.003..0.003 rows=0 loops=295352)

  • Index Cond: (alpha_whiskey.mike_kilo = golf_romeo.mike_kilo)
  • Filter: (alpha_whiskey.two_uniform = ANY ('whiskey'::bpchar[]))
31. 512.456 512.456 ↑ 1.0 1 128114

Index Scan using quebec_charlie on charlie_four (cost=0.000..0.280 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=128114)

  • Index Cond: (charlie_four.november_bravo = seven_november.quebec_seven)
32. 543.252 543.252 ↑ 1.0 1 135813

Index Scan using quebec_victor on three_echo (cost=0.000..0.330 rows=1 width=21) (actual time=0.004..0.004 rows=1 loops=135813)

  • Index Cond: (three_echo.quebec_seven = delta.four_sierra)
33. 543.252 543.252 ↑ 1.0 1 135813

Index Scan using golf_foxtrot_two on india_whiskey (cost=0.000..4.280 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=135813)

  • Index Cond: (india_whiskey.romeo_papa = romeo_xray.quebec_seven)
34. 797.466 797.466 ↑ 1.0 1 132911

Index Scan using quebec_papa on six_whiskey (cost=0.000..4.300 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=132911)

  • Index Cond: ((six_whiskey.romeo_papa = romeo_xray.quebec_seven) AND (six_whiskey.bravo_romeo = 'kilo_zulu'::bpchar))