explain.depesz.com

PostgreSQL's explain analyze made readable

Result: resW : 1

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=870,580.010..870,581.540 rows=15 width=726) (actual rows= loops=)

2.          

CTE sierra_six

3. 0.000 0.000 ↓ 0.0

Limit (cost=0.560..0.870 rows=2 width=32) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Unique (cost=0.560..2,037,842.860 rows=13,158,587 width=32) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot_november on quebec_two tango_delta (cost=0.560..2,004,946.390 rows=13,158,587 width=32) (actual rows= loops=)

  • Filter: ((whiskey_sierra < 2) AND (whiskey_sierra < 2))
6.          

CTE charlie_lima

7. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0.050..0.090 rows=2 width=40) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Sort (cost=0.050..0.060 rows=2 width=32) (actual rows= loops=)

  • Sort Key: charlie_sierra3848145five_hotel2three_oscar530."kilo_lima", charlie_sierra3848145five_hotel2three_oscar530."2
9. 0.000 0.000 ↓ 0.0

CTE Scan on sierra_six (cost=0.000..0.040 rows=2 width=32) (actual rows= loops=)

10.          

CTE golf_quebec

11. 0.000 0.000 ↓ 0.0

Limit (cost=0.060..0.060 rows=1 width=32) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Sort (cost=0.060..0.060 rows=1 width=32) (actual rows= loops=)

  • Sort Key: kilo_charlie3848145five_hotel2quebec_sierra1quebec_sierra40."2
13. 0.000 0.000 ↓ 0.0

CTE Scan on charlie_lima (cost=0.000..0.040 rows=1 width=32) (actual rows= loops=)

  • Filter: (six_golf = 1)
14. 0.000 0.000 ↓ 0.0

Sort (cost=870,578.990..870,579.020 rows=15 width=726) (actual rows= loops=)

  • Sort Key: charlie_hotel0.four, romeo_three1kilo_oscar0.victor_yankee, charlie_hotel0.seven_mike, charlie_hotel3.sierra_mike, charlie_hotel4.india_delta, charlie_hotel0.six_alpha, charlie_hotel0.charlie_papa, charlie_hotel0.romeo_november, charlie_hotel0.two_oscar, charlie_hotel0.seven_seven, charlie_hotel0.romeo_yankee, charlie_hotel0.golf_whiskey, charlie_hotel0.quebec_yankee, charlie_hotel0.tango_golf, charlie_hotel0.two_seven, charlie_hotel0.alpha_victor, charlie_hotel0.yankee, charlie_hotel0.bravo_november, charlie_hotel0.quebec_charlie, charlie_hotel0.alpha_four, charlie_hotel0.oscar_whiskey, charlie_hotel7.victor_quebec, charlie_hotel5.six_oscar, charlie_hotel0.mike_three, charlie_hotel6.romeo_zulu, charlie_hotel0.five_victor, charlie_hotel1.whiskey_delta, charlie_hotel2.juliet_seven, charlie_hotel0.mike_alpha, charlie_hotel0.xray_three, charlie_hotel0.golf_sierra, romeo_three1kilo_oscar0.oscar_golf, romeo_three1kilo_oscar0.juliet_golf, romeo_three1kilo_oscar0.mike_juliet, romeo_three1kilo_oscar0.november, romeo_three1kilo_oscar0.delta, romeo_three1kilo_oscar0.seven_six, romeo_three1kilo_oscar0.five_alpha, romeo_three1kilo_oscar0.echo, romeo_three1kilo_oscar0.foxtrot_six
15. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=66.520..870,578.690 rows=15 width=726) (actual rows= loops=)

  • -> Index Scan using ai_aioidconfidencemapping_26071 on aioidconfidencemapping t1_0 (cost=0.56..0.95 rows=15 width=60)" Index Cond: ((keytable = 117) AND (keyminamespace = 67) AND ((x0.mpfdamfrsndr)::text = (oidvendor)::text))
16. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=65.960..870,577.590 rows=1 width=650) (actual rows= loops=)

  • Hash Cond: (charlie_hotel0.four = charlie_quebec3848145five_hotel2quebec_sierra1quebec_sierra40."kilo_lima")
17. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=65.930..836,036.260 rows=13,158,587 width=650) (actual rows= loops=)

  • Hash Cond: (charlie_hotel0.quebec_bravo = charlie_hotel7.quebec_bravo)
18. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=53.590..800,498.370 rows=13,158,587 width=630) (actual rows= loops=)

  • Hash Cond: (charlie_hotel0.oscar_quebec = charlie_hotel6.oscar_quebec)
19. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=52.100..764,748.970 rows=13,158,587 width=576) (actual rows= loops=)

  • Hash Cond: (charlie_hotel0.golf_tango = charlie_hotel5.golf_tango)
20. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=50.750..723,876.740 rows=13,158,587 width=556) (actual rows= loops=)

  • Hash Cond: (charlie_hotel0.tango_kilo = charlie_hotel4.tango_kilo)
21. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=34.910..689,271.250 rows=13,158,587 width=512) (actual rows= loops=)

  • Hash Cond: (charlie_hotel0.five_three = charlie_hotel3.five_three)
22. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=33.330..652,017.800 rows=13,158,587 width=484) (actual rows= loops=)

  • Hash Cond: (charlie_hotel0.golf_kilo = charlie_hotel2.golf_kilo)
23. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=17.160..617,064.690 rows=13,158,587 width=452) (actual rows= loops=)

  • Hash Cond: (charlie_hotel0.three_seven = charlie_hotel1.three_seven)
24. 0.000 0.000 ↓ 0.0

Seq Scan on quebec_two foxtrot_romeo (cost=0.000..582,165.800 rows=13,158,587 width=448) (actual rows= loops=)

  • Filter: ((whiskey_sierra < 2) AND (whiskey_sierra < 2))
25. 0.000 0.000 ↓ 0.0

Hash (cost=15.380..15.380 rows=143 width=12) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Seq Scan on bravo_six charlie_three (cost=0.000..15.380 rows=143 width=12) (actual rows= loops=)

  • Filter: (whiskey_sierra < 2)
27. 0.000 0.000 ↓ 0.0

Hash (cost=14.620..14.620 rows=123 width=40) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Seq Scan on xray_uniform two_quebec (cost=0.000..14.620 rows=123 width=40) (actual rows= loops=)

  • Filter: (whiskey_sierra < 2)
29. 0.000 0.000 ↓ 0.0

Hash (cost=1.440..1.440 rows=12 width=36) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Seq Scan on foxtrot_victor charlie_xray (cost=0.000..1.440 rows=12 width=36) (actual rows= loops=)

  • Filter: (whiskey_sierra < 2)
31. 0.000 0.000 ↓ 0.0

Hash (cost=14.380..14.380 rows=117 width=52) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Seq Scan on golf_lima foxtrot_papa (cost=0.000..14.380 rows=117 width=52) (actual rows= loops=)

  • Filter: (whiskey_sierra < 2)
33. 0.000 0.000 ↓ 0.0

Hash (cost=1.260..1.260 rows=7 width=28) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Seq Scan on kilo_mike india_alpha (cost=0.000..1.260 rows=7 width=28) (actual rows= loops=)

  • Filter: (whiskey_sierra < 2)
35. 0.000 0.000 ↓ 0.0

Hash (cost=1.360..1.360 rows=10 width=62) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Seq Scan on golf_foxtrot five_delta (cost=0.000..1.360 rows=10 width=62) (actual rows= loops=)

  • Filter: (whiskey_sierra < 2)
37. 0.000 0.000 ↓ 0.0

Hash (cost=11.750..11.750 rows=47 width=28) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_lima xray_sierra (cost=0.000..11.750 rows=47 width=28) (actual rows= loops=)

  • Filter: (whiskey_sierra < 2)
39. 0.000 0.000 ↓ 0.0

Hash (cost=0.020..0.020 rows=1 width=16) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

CTE Scan on golf_quebec (cost=0.000..0.020 rows=1 width=16) (actual rows= loops=)