explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aQqA : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #XHT8; plan #VT6p; plan #3B7m; plan #i57iN; plan #kmS; plan #1cmJ; plan #O7Gn; plan #KqxH; plan #FpgV; plan #y4xt; plan #4Rms

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.014 27.425 ↑ 2.2 92 1

Limit (cost=8,203.84..8,204.35 rows=203 width=5,492) (actual time=27.394..27.425 rows=92 loops=1)

2. 0.319 27.411 ↑ 2.2 92 1

Sort (cost=8,203.84..8,204.35 rows=203 width=5,492) (actual time=27.393..27.411 rows=92 loops=1)

  • Sort Key: lima_delta1.quebec_seven
  • Sort Method: quicksort Memory: 402kB
3. 0.137 27.092 ↑ 2.2 92 1

Nested Loop Left Join (cost=200.37..8,196.06 rows=203 width=5,492) (actual time=0.555..27.092 rows=92 loops=1)

4. 0.113 26.863 ↑ 2.2 92 1

Nested Loop Left Join (cost=200.09..8,100.66 rows=203 width=4,041) (actual time=0.548..26.863 rows=92 loops=1)

5. 0.073 26.750 ↑ 2.2 92 1

Nested Loop (cost=199.81..8,040.77 rows=203 width=2,028) (actual time=0.543..26.750 rows=92 loops=1)

6. 0.077 26.493 ↑ 2.2 92 1

Nested Loop (cost=199.53..7,981.38 rows=203 width=1,706) (actual time=0.531..26.493 rows=92 loops=1)

7. 0.065 25.951 ↑ 2.2 93 1

Nested Loop (cost=199.10..7,468.24 rows=201 width=1,650) (actual time=0.517..25.951 rows=93 loops=1)

8. 0.012 0.012 ↑ 1.0 1 1

Index Scan using two_delta on echo_zulu mike (cost=0.27..2.49 rows=1 width=664) (actual time=0.010..0.012 rows=1 loops=1)

  • Index Cond: (quebec_seven = 81)
9. 0.132 25.874 ↑ 2.2 93 1

Nested Loop (cost=198.83..7,463.74 rows=201 width=986) (actual time=0.501..25.874 rows=93 loops=1)

10. 0.074 25.649 ↑ 2.2 93 1

Nested Loop (cost=198.69..7,433.09 rows=201 width=938) (actual time=0.494..25.649 rows=93 loops=1)

11. 0.146 25.296 ↑ 2.2 93 1

Nested Loop (cost=198.41..7,359.15 rows=201 width=813) (actual time=0.484..25.296 rows=93 loops=1)

12. 0.096 24.871 ↑ 2.2 93 1

Hash Join (cost=198.13..7,255.30 rows=209 width=528) (actual time=0.471..24.871 rows=93 loops=1)

  • Hash Cond: (lima_delta1.lima_echo = alpha1.uniform_bravo)
13. 24.394 24.394 ↑ 32.3 93 1

Index Scan using papa_yankee on foxtrot_romeo quebec_sierra (cost=0.56..7,049.84 rows=3,000 width=295) (actual time=0.081..24.394 rows=93 loops=1)

  • Index Cond: ((lima_romeo)::text = 'quebec_quebec'::text)
  • Filter: (((NOT papa_bravo) OR (papa_bravo five_romeo NULL)) AND (juliet_hotel = 81))
  • Rows Removed by Filter: 26,911
14. 0.138 0.381 ↓ 1.0 352 1

Hash (cost=193.23..193.23 rows=347 width=233) (actual time=0.380..0.381 rows=352 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 149kB
15. 0.243 0.243 ↓ 1.0 352 1

Index Scan using five_victor on delta_alpha five_xray (cost=0.28..193.23 rows=347 width=233) (actual time=0.010..0.243 rows=352 loops=1)

  • Index Cond: (foxtrot_charlie = 81)
16. 0.279 0.279 ↑ 1.0 1 93

Index Scan using sierra_delta on sierra_three whiskey_six (cost=0.28..0.50 rows=1 width=285) (actual time=0.003..0.003 rows=1 loops=93)

  • Index Cond: (quebec_seven = lima_delta1.lima_echo)
17. 0.279 0.279 ↑ 1.0 1 93

Index Scan using kilo_charlie on golf uniform_romeo_zulu (cost=0.28..0.37 rows=1 width=125) (actual time=0.003..0.003 rows=1 loops=93)

  • Index Cond: (quebec_seven = lima_delta1.two_romeo)
18. 0.093 0.093 ↑ 1.0 1 93

Index Scan using uniform_romeo_romeo on tango four_uniform (cost=0.14..0.15 rows=1 width=48) (actual time=0.001..0.001 rows=1 loops=93)

  • Index Cond: (quebec_seven = lima_delta1.four_sierra)
19. 0.465 0.465 ↑ 1.0 1 93

Index Scan using charlie on uniform_kilo victor (cost=0.43..2.54 rows=1 width=56) (actual time=0.005..0.005 rows=1 loops=93)

  • Index Cond: (sierra_foxtrot = lima_delta1.quebec_seven)
20. 0.184 0.184 ↑ 1.0 1 92

Index Scan using kilo_kilo on oscar yankee (cost=0.28..0.29 rows=1 width=322) (actual time=0.002..0.002 rows=1 loops=92)

  • Index Cond: (quebec_seven = echo_seven1.four_delta)
21. 0.000 0.000 ↓ 0.0 0 92

Index Scan using uniform_golf on whiskey_tango hotel (cost=0.28..0.30 rows=1 width=2,013) (actual time=0.000..0.000 rows=0 loops=92)

  • Index Cond: (echo_seven1.delta_kilo = quebec_seven)
22. 0.092 0.092 ↓ 0.0 0 92

Index Scan using five_oscar on juliet_november romeo (cost=0.28..0.46 rows=1 width=1,443) (actual time=0.001..0.001 rows=0 loops=92)

  • Index Cond: (lima_delta1.quebec_seven = sierra_foxtrot)
Planning time : 13.579 ms
Execution time : 27.909 ms