explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ro9M : Optimization for: plan #aUPR

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 2.100 94.811 ↓ 582.0 582 1

Nested Loop (cost=2.830..2,719.230 rows=1 width=1,764) (actual time=0.196..94.811 rows=582 loops=1)

2. 0.438 44.987 ↓ 582.0 582 1

Nested Loop (cost=2.400..2,696.190 rows=1 width=1,759) (actual time=0.111..44.987 rows=582 loops=1)

3. 6.414 33.491 ↓ 582.0 582 1

Nested Loop Left Join (cost=1.970..2,695.730 rows=1 width=1,757) (actual time=0.095..33.491 rows=582 loops=1)

  • Join Filter: (sierra_lima1.quebec_seven = foxtrot_three.zulu)
  • Rows Removed by Join Filter: 40,158
4. 0.460 20.093 ↓ 582.0 582 1

Nested Loop Left Join (cost=1.970..2,692.150 rows=1 width=1,704) (actual time=0.076..20.093 rows=582 loops=1)

5. 0.447 14.395 ↓ 582.0 582 1

Nested Loop (cost=1.570..2,690.750 rows=1 width=1,556) (actual time=0.065..14.395 rows=582 loops=1)

6. 0.659 9.252 ↓ 1.1 587 1

Nested Loop (cost=1.140..2,440.600 rows=528 width=8) (actual time=0.049..9.252 rows=587 loops=1)

7. 2.136 2.136 ↓ 1.1 587 1

Index Scan using victor_seven on bravo (cost=0.570..488.520 rows=543 width=8) (actual time=0.033..2.136 rows=587 loops=1)

  • Index Cond: ((juliet_charlie)::text = 'november'::text)
8. 6.457 6.457 ↑ 1.0 1 587

Index Scan using xray on four (cost=0.570..3.580 rows=1 width=12) (actual time=0.010..0.011 rows=1 loops=587)

  • Index Cond: (mike_india = bravo.quebec_seven)
9. 4.696 4.696 ↑ 1.0 1 587

Index Scan using papa_papa on foxtrot_three (cost=0.430..0.460 rows=1 width=1,548) (actual time=0.008..0.008 rows=1 loops=587)

  • Index Cond: (quebec_seven = four.tango)
  • Filter: ((golf)::text = 'papa_mike'::text)
  • Rows Removed by Filter: 0
10. 5.238 5.238 ↑ 1.0 1 582

Index Scan using kilo_delta on two five (cost=0.400..1.390 rows=1 width=148) (actual time=0.007..0.009 rows=1 loops=582)

  • Index Cond: (quebec_seven = foxtrot_three.sierra_three)
11. 6.984 6.984 ↑ 1.0 70 582

Seq Scan on whiskey quebec_golf (cost=0.000..2.700 rows=70 width=53) (actual time=0.002..0.012 rows=70 loops=582)

12. 11.058 11.058 ↑ 1.0 1 582

Index Scan using alpha on seven (cost=0.430..0.450 rows=1 width=10) (actual time=0.019..0.019 rows=1 loops=582)

  • Index Cond: (quebec_seven = four.victor_hotel)
13. 2.910 2.910 ↑ 1.0 1 582

Index Scan using papa_papa on foxtrot_three papa_charlie (cost=0.430..0.460 rows=1 width=13) (actual time=0.004..0.005 rows=1 loops=582)

  • Index Cond: (quebec_seven = four.tango)
14.          

SubPlan (for Nested Loop)

15. 0.000 21.534 ↑ 1.0 1 582

Limit (cost=0.850..6.900 rows=1 width=23) (actual time=0.037..0.037 rows=1 loops=582)

16. 1.164 21.534 ↑ 1.0 1 582

Nested Loop (cost=0.850..6.900 rows=1 width=23) (actual time=0.037..0.037 rows=1 loops=582)

17. 16.296 16.296 ↑ 1.0 1 582

Index Only Scan using foxtrot_bravo on lima_lima (cost=0.430..3.450 rows=1 width=4) (actual time=0.028..0.028 rows=1 loops=582)

  • Index Cond: (quebec_seven = foxtrot_three.kilo_uniform)
  • Heap Fetches: 582
18. 4.074 4.074 ↑ 1.0 1 582

Index Scan using lima_mike on victor_kilo (cost=0.430..3.450 rows=1 width=27) (actual time=0.007..0.007 rows=1 loops=582)

  • Index Cond: (quebec_seven = lima_lima.foxtrot_uniform)
19. 0.582 7.566 ↑ 1.0 1 582

Limit (cost=3.460..4.610 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=582)

20. 4.114 6.984 ↑ 1.0 1 582

Hash Join (cost=3.460..4.610 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=582)

  • Hash Cond: (three.quebec_seven = juliet_romeo1.oscar)
21. 0.542 0.542 ↑ 1.4 7 542

Seq Scan on three (cost=0.000..1.100 rows=10 width=12) (actual time=0.001..0.001 rows=7 loops=542)

22. 0.582 2.328 ↑ 1.0 1 582

Hash (cost=3.450..3.450 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=582)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
23. 1.746 1.746 ↑ 1.0 1 582

Index Scan using foxtrot_bravo on lima_lima six_zulu (cost=0.430..3.450 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=582)

  • Index Cond: (quebec_seven = foxtrot_three.kilo_uniform)
24. 0.000 1.746 ↑ 1.0 1 582

Limit (cost=0.430..3.450 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=582)

25. 1.746 1.746 ↑ 1.0 1 582

Index Scan using foxtrot_bravo on lima_lima six_echo (cost=0.430..3.450 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=582)

  • Index Cond: (quebec_seven = foxtrot_three.kilo_uniform)
26. 1.164 13.968 ↑ 1.0 1 582

Aggregate (cost=7.610..7.620 rows=1 width=0) (actual time=0.024..0.024 rows=1 loops=582)

27. 12.804 12.804 ↑ 1.0 1 582

Index Scan using romeo on mike_oscar (cost=0.270..7.610 rows=1 width=0) (actual time=0.011..0.022 rows=1 loops=582)

  • Filter: (zulu = sierra_lima1.quebec_seven)
  • Rows Removed by Filter: 6
Planning time : 4.050 ms
Execution time : 95.104 ms