explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uprv

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

Hash Join (cost=357,039.740..902,192.690 rows=5,578 width=8,814) (actual rows= loops=)

  • Hash Cond: ((alpha_seven3.victor_tango)::text = (november_mike_golf5.quebec)::text)
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=357,037.620..902,146.790 rows=5,578 width=8,641) (actual rows= loops=)

  • Hash Cond: ((alpha_seven1.victor_tango)::text = (lima6.quebec)::text)
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=357,034.490..902,127.780 rows=5,578 width=8,623) (actual rows= loops=)

  • Hash Cond: (alpha_seven4.quebec = alpha_seven14.quebec)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=357,024.270..902,102.910 rows=5,578 width=7,993) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=357,023.840..861,906.500 rows=5,578 width=7,921) (actual rows= loops=)

  • Join Filter: (alpha_seven1.quebec = alpha_seven8.zulu_six)
6. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=357,023.410..821,815.040 rows=5,580 width=7,853) (actual rows= loops=)

  • Hash Cond: (alpha_seven1.romeo_tango = alpha_seven2.quebec)
7. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=304,132.110..768,754.460 rows=64,487 width=7,833) (actual rows= loops=)

  • Merge Cond: (alpha_seven4.quebec = alpha_seven11.quebec)
8. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=304,118.780..768,579.500 rows=64,487 width=7,353) (actual rows= loops=)

  • Merge Cond: (alpha_seven4.quebec = alpha_seven13.quebec)
9. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=304,104.460..768,403.450 rows=64,487 width=7,113) (actual rows= loops=)

  • Merge Cond: (alpha_seven4.quebec = alpha_seven12.quebec)
10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=304,090.140..768,227.400 rows=64,487 width=6,993) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=304,089.700..304,412.150 rows=64,487 width=3,333) (actual rows= loops=)

  • Merge Cond: (alpha_seven4.quebec = alpha_seven9.quebec)
12. 0.000 0.000 ↓ 0.0

Sort (cost=304,077.030..304,238.250 rows=64,487 width=3,253) (actual rows= loops=)

  • Sort Key: alpha_seven4.quebec
13. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=194,150.900..298,925.580 rows=64,487 width=3,253) (actual rows= loops=)

  • Hash Cond: (alpha_seven3.quebec = alpha_seven4.alpha_romeo)
14. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on sierra_quebec yankee_oscar (cost=0.000..101,369.350 rows=836,435 width=549) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=193,344.810..193,344.810 rows=64,487 width=2,710) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=103,886.970..193,344.810 rows=64,487 width=2,710) (actual rows= loops=)

  • Hash Cond: (alpha_seven4.zulu_six = alpha_seven1.quebec)
17. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on seven_six victor_november (cost=0.000..82,872.030 rows=2,508,875 width=24) (actual rows= loops=)

  • Filter: ((bravo)::text = ANY ('yankee_romeo'::text[]))
18. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=103,618.200..103,618.200 rows=21,502 width=2,686) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on sierra_three hotel (cost=0.000..103,618.200 rows=21,502 width=2,686) (actual rows= loops=)

  • Filter: ((four_lima >= papa_delta('two_lima'::text, 'india'::text)) AND (four_lima <= papa_delta('papa_alpha'::text, 'india'::text)))
20. 0.000 0.000 ↓ 0.0

Sort (cost=12.370..12.520 rows=60 width=86) (actual rows= loops=)

  • Sort Key: alpha_seven9.quebec
21. 0.000 0.000 ↓ 0.0

Seq Scan on zulu_golf three_quebec (cost=0.000..10.600 rows=60 width=86) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Index Scan using charlie_yankee on romeo_five four_papa (cost=0.430..7.180 rows=1 width=3,666) (actual rows= loops=)

  • Index Cond: (alpha_seven4.quebec = quebec)
23. 0.000 0.000 ↓ 0.0

Sort (cost=14.320..14.570 rows=100 width=140) (actual rows= loops=)

  • Sort Key: alpha_seven12.quebec
24. 0.000 0.000 ↓ 0.0

Seq Scan on five_three three_uniform (cost=0.000..11.000 rows=100 width=140) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Sort (cost=14.320..14.570 rows=100 width=260) (actual rows= loops=)

  • Sort Key: alpha_seven13.quebec
26. 0.000 0.000 ↓ 0.0

Seq Scan on papa_hotel mike (cost=0.000..11.000 rows=100 width=260) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Sort (cost=13.330..13.530 rows=80 width=500) (actual rows= loops=)

  • Sort Key: alpha_seven11.quebec
28. 0.000 0.000 ↓ 0.0

Seq Scan on november_mike_oscar five_six (cost=0.000..10.800 rows=80 width=500) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=51,987.760..51,987.760 rows=72,283 width=26) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on three_two sierra_victor (cost=0.000..51,987.760 rows=72,283 width=26) (actual rows= loops=)

  • Filter: ((seven_papa >= 'four_uniform'::numeric) AND (seven_papa <= 'four_uniform'::numeric))
31. 0.000 0.000 ↓ 0.0

Index Scan using seven_echo on charlie_lima sierra_whiskey (cost=0.430..7.170 rows=1 width=80) (actual rows= loops=)

  • Index Cond: (zulu_six = alpha_seven4.zulu_six)
32. 0.000 0.000 ↓ 0.0

Index Scan using kilo on november_two whiskey_papa (cost=0.430..7.200 rows=1 width=78) (actual rows= loops=)

  • Index Cond: (quebec = alpha_seven4.quebec)
33. 0.000 0.000 ↓ 0.0

Hash (cost=10.100..10.100 rows=10 width=650) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_delta xray (cost=0.000..10.100 rows=10 width=650) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Hash (cost=2.500..2.500 rows=50 width=18) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Seq Scan on five_papa papa_charlie (cost=0.000..2.500 rows=50 width=18) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Hash (cost=1.500..1.500 rows=50 width=18) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Seq Scan on two_kilo five_romeo (cost=0.000..1.500 rows=50 width=18) (actual rows= loops=)