explain.depesz.com

A tool for finding a real cause for slow queries.

Result: wZ3

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 109.548 521.722 ↑ 1.0 64,084 1

Sort (cost=33,789.640..33,949.850 rows=64,084 width=66) (actual time=498.826..521.722 rows=64,084 loops=1)

  • Sort Key: two_oscar.november
  • Sort Method: external merge Disk: 5040kB
2. 45.644 412.174 ↑ 1.0 64,084 1

Hash Join (cost=7,969.140..26,044.770 rows=64,084 width=66) (actual time=98.261..412.174 rows=64,084 loops=1)

  • Hash Cond: (two_oscar.golf_lima = bravo.quebec_seven)
3. 54.206 357.497 ↑ 1.0 64,084 1

Hash Join (cost=7,130.170..22,499.230 rows=64,084 width=61) (actual time=89.215..357.497 rows=64,084 loops=1)

  • Hash Cond: ((zulu_quebec.golf_victor)::text = (xray_xray.three)::text)
4. 24.656 288.676 ↑ 1.0 64,084 1

Hash Join (cost=5,909.270..18,271.440 rows=64,084 width=64) (actual time=74.588..288.676 rows=64,084 loops=1)

  • Hash Cond: (seven_victor_six.golf_lima = two_oscar.golf_lima)
5. 32.704 263.798 ↑ 1.0 64,084 1

Hash Join (cost=5,891.120..17,372.130 rows=64,084 width=52) (actual time=74.357..263.798 rows=64,084 loops=1)

  • Hash Cond: ((seven_victor_six.golf_victor)::text = (zulu_quebec.golf_victor)::text)
6. 53.220 226.307 ↑ 1.0 64,084 1

Hash Join (cost=5,568.290..16,168.150 rows=64,084 width=38) (actual time=69.561..226.307 rows=64,084 loops=1)

  • Hash Cond: (two_echo.xray_six = seven_victor_six.quebec_seven)
7. 30.672 103.934 ↑ 1.0 64,084 1

Merge Join (cost=0.000..8,105.070 rows=64,084 width=24) (actual time=0.062..103.934 rows=64,084 loops=1)

  • Merge Cond: (two_echo.quebec_seven = four.quebec_seven)
8. 31.790 58.760 ↑ 1.0 64,084 1

Merge Join (cost=0.000..5,062.290 rows=64,084 width=16) (actual time=0.042..58.760 rows=64,084 loops=1)

  • Merge Cond: (two_echo.quebec_seven = uniform.quebec_seven)
9. 14.121 14.121 ↑ 1.0 64,084 1

Index Scan using six on two_echo (cost=0.000..2,144.520 rows=64,084 width=8) (actual time=0.019..14.121 rows=64,084 loops=1)

10. 12.849 12.849 ↑ 1.0 64,084 1

Index Scan using seven_victor_sierra on uniform (cost=0.000..1,956.520 rows=64,084 width=8) (actual time=0.019..12.849 rows=64,084 loops=1)

11. 14.502 14.502 ↑ 1.0 64,084 1

Index Scan using golf_foxtrot on four (cost=0.000..2,081.520 rows=64,084 width=20) (actual time=0.018..14.502 rows=64,084 loops=1)

12. 17.205 69.153 ↑ 1.0 55,663 1

Hash (cost=4,491.500..4,491.500 rows=55,663 width=26) (actual time=69.153..69.153 rows=55,663 loops=1)

13. 26.063 51.948 ↑ 1.0 55,663 1

Merge Join (cost=0.000..4,491.500 rows=55,663 width=26) (actual time=0.041..51.948 rows=55,663 loops=1)

  • Merge Cond: (seven_victor_six.quebec_seven = echo.quebec_seven)
14. 10.042 10.042 ↑ 1.0 55,663 1

Index Scan using lima on seven_victor_six (cost=0.000..1,816.200 rows=55,663 width=18) (actual time=0.019..10.042 rows=55,663 loops=1)

15. 15.843 15.843 ↑ 1.0 55,663 1

Index Scan using zulu_five on echo (cost=0.000..1,840.360 rows=55,663 width=8) (actual time=0.020..15.843 rows=55,663 loops=1)

  • Filter: ((echo.delta five NULL) AND (echo.alpha = 1))
16. 1.787 4.787 ↑ 1.0 7,416 1

Hash (cost=230.130..230.130 rows=7,416 width=22) (actual time=4.787..4.787 rows=7,416 loops=1)

17. 1.560 3.000 ↑ 1.0 7,416 1

Nested Loop (cost=0.000..230.130 rows=7,416 width=22) (actual time=0.024..3.000 rows=7,416 loops=1)

18. 0.014 0.014 ↑ 1.0 1 1

Index Scan using juliet on quebec_victor (cost=0.000..8.270 rows=1 width=4) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (quebec_seven = 1)
19. 1.426 1.426 ↑ 1.0 7,416 1

Seq Scan on zulu_quebec (cost=0.000..147.700 rows=7,416 width=18) (actual time=0.008..1.426 rows=7,416 loops=1)

  • Filter: (zulu_quebec.alpha = 1)
20. 0.098 0.222 ↑ 1.0 566 1

Hash (cost=11.070..11.070 rows=566 width=12) (actual time=0.222..0.222 rows=566 loops=1)

21. 0.124 0.124 ↑ 1.0 566 1

Seq Scan on two_oscar (cost=0.000..11.070 rows=566 width=12) (actual time=0.011..0.124 rows=566 loops=1)

  • Filter: (alpha = 1)
22. 8.711 14.615 ↑ 1.0 31,818 1

Hash (cost=636.180..636.180 rows=31,818 width=17) (actual time=14.615..14.615 rows=31,818 loops=1)

23. 5.904 5.904 ↑ 1.0 31,818 1

Seq Scan on xray_xray (cost=0.000..636.180 rows=31,818 width=17) (actual time=0.007..5.904 rows=31,818 loops=1)

24. 4.838 9.033 ↑ 1.0 21,643 1

Hash (cost=441.430..441.430 rows=21,643 width=17) (actual time=9.033..9.033 rows=21,643 loops=1)

25. 4.195 4.195 ↑ 1.0 21,643 1

Seq Scan on bravo (cost=0.000..441.430 rows=21,643 width=17) (actual time=0.012..4.195 rows=21,643 loops=1)