explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YpgJ : Optimization for: plan #x0eS

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 111.213 39,725.412 ↑ 1.1 9,496 1

Hash Left Join (cost=5,244.420..7,130,555.370 rows=10,420 width=1,749) (actual time=57.471..39,725.412 rows=9,496 loops=1)

  • Hash Cond: (foxtrot_three.zulu = sierra_lima1.quebec_seven)
2. 85.710 703.186 ↑ 1.1 9,496 1

Hash Left Join (cost=5,240.840..17,989.750 rows=10,420 width=1,696) (actual time=26.285..703.186 rows=9,496 loops=1)

  • Hash Cond: (foxtrot_three.sierra_three = hotel1.quebec_seven)
3. 591.239 591.239 ↑ 1.1 9,496 1

Index Scan using foxtrot_two on foxtrot_three (cost=0.560..12,612.480 rows=10,420 width=1,548) (actual time=0.035..591.239 rows=9,496 loops=1)

  • Index Cond: ((golf)::text = 'papa'::text)
4. 1.270 26.237 ↑ 1.0 2,033 1

Hash (cost=5,214.870..5,214.870 rows=2,033 width=148) (actual time=26.237..26.237 rows=2,033 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 352kB
5. 24.967 24.967 ↑ 1.0 2,033 1

Index Scan using kilo_delta on two five (cost=0.400..5,214.870 rows=2,033 width=148) (actual time=0.004..24.967 rows=2,033 loops=1)

6. 0.013 0.065 ↑ 1.0 70 1

Hash (cost=2.700..2.700 rows=70 width=53) (actual time=0.065..0.065 rows=70 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
7. 0.052 0.052 ↑ 1.0 70 1

Seq Scan on whiskey quebec_golf (cost=0.000..2.700 rows=70 width=53) (actual time=0.006..0.052 rows=70 loops=1)

8.          

SubPlan (for Hash Left Join)

9. 1.262 30,497.492 ↑ 1.0 1 631

Limit (cost=166.780..661.420 rows=1 width=6) (actual time=48.331..48.332 rows=1 loops=631)

10. 50.223 30,496.230 ↑ 1.0 1 631

Nested Loop (cost=166.780..661.420 rows=1 width=6) (actual time=48.330..48.330 rows=1 loops=631)

11. 71.303 30,409.152 ↑ 1.0 1 631

Hash Join (cost=166.350..657.980 rows=1 width=4) (actual time=48.192..48.192 rows=1 loops=631)

  • Hash Cond: (bravo.quebec_seven = four.mike_india)
12. 30,276.011 30,276.011 ↑ 1.7 316 631

Index Scan using victor_seven on bravo (cost=0.570..490.150 rows=545 width=8) (actual time=1.291..47.981 rows=316 loops=631)

  • Index Cond: ((juliet_charlie)::text = 'november'::text)
13. 10.727 61.838 ↑ 20.9 17 631

Hash (cost=161.340..161.340 rows=355 width=8) (actual time=0.098..0.098 rows=17 loops=631)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
14. 51.111 51.111 ↑ 20.9 17 631

Index Scan using charlie on four (cost=0.570..161.340 rows=355 width=8) (actual time=0.076..0.081 rows=17 loops=631)

  • Index Cond: (tango = foxtrot_three.quebec_seven)
15. 36.855 36.855 ↑ 1.0 1 585

Index Scan using alpha on seven (cost=0.430..3.430 rows=1 width=10) (actual time=0.063..0.063 rows=1 loops=585)

  • Index Cond: (quebec_seven = four.victor_hotel)
16. 28.488 854.640 ↑ 1.0 1 9,496

Limit (cost=0.850..6.900 rows=1 width=23) (actual time=0.090..0.090 rows=1 loops=9,496)

17. 56.976 826.152 ↑ 1.0 1 9,496

Nested Loop (cost=0.850..6.900 rows=1 width=23) (actual time=0.087..0.087 rows=1 loops=9,496)

18. 465.304 465.304 ↑ 1.0 1 9,496

Index Only Scan using foxtrot_bravo on lima_lima (cost=0.430..3.450 rows=1 width=4) (actual time=0.049..0.049 rows=1 loops=9,496)

  • Index Cond: (quebec_seven = foxtrot_three.kilo_uniform)
  • Heap Fetches: 9,493
19. 303.872 303.872 ↑ 1.0 1 9,496

Index Scan using lima_mike on victor_kilo (cost=0.430..3.450 rows=1 width=27) (actual time=0.032..0.032 rows=1 loops=9,496)

  • Index Cond: (quebec_seven = lima_lima.foxtrot_uniform)
20. 417.824 883.128 ↑ 1.0 1 9,496

Limit (cost=3.460..4.610 rows=1 width=8) (actual time=0.093..0.093 rows=1 loops=9,496)

21. 184.904 465.304 ↑ 1.0 1 9,496

Hash Join (cost=3.460..4.610 rows=1 width=8) (actual time=0.049..0.049 rows=1 loops=9,496)

  • Hash Cond: (three.quebec_seven = juliet_romeo1.oscar)
22. 61.992 61.992 ↑ 1.7 6 8,856

Seq Scan on three (cost=0.000..1.100 rows=10 width=12) (actual time=0.006..0.007 rows=6 loops=8,856)

23. 37.984 218.408 ↑ 1.0 1 9,496

Hash (cost=3.450..3.450 rows=1 width=4) (actual time=0.023..0.023 rows=1 loops=9,496)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
24. 180.424 180.424 ↑ 1.0 1 9,496

Index Scan using foxtrot_bravo on lima_lima six_zulu (cost=0.430..3.450 rows=1 width=4) (actual time=0.009..0.019 rows=1 loops=9,496)

  • Index Cond: (quebec_seven = foxtrot_three.kilo_uniform)
25. 9.496 56.976 ↑ 1.0 1 9,496

Limit (cost=0.430..3.450 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=9,496)

26. 47.480 47.480 ↑ 1.0 1 9,496

Index Scan using foxtrot_bravo on lima_lima six_echo (cost=0.430..3.450 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=9,496)

  • Index Cond: (quebec_seven = foxtrot_three.kilo_uniform)
27. 18.992 6,618.712 ↑ 1.0 1 9,496

Aggregate (cost=6.190..6.200 rows=1 width=0) (actual time=0.697..0.697 rows=1 loops=9,496)

28. 6,599.720 6,599.720 ↓ 0.0 0 9,496

Index Scan using romeo on mike_oscar (cost=0.270..6.190 rows=1 width=0) (actual time=0.622..0.695 rows=0 loops=9,496)

  • Filter: (zulu = sierra_lima1.quebec_seven)
  • Rows Removed by Filter: 10
Planning time : 4.642 ms
Execution time : 39,727.084 ms