explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aFCE : Optimization for: 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; plan #aQqA

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.012 28.458 ↑ 2.2 92 1

Limit (cost=8,311.48..8,325.18 rows=203 width=554) (actual time=28.341..28.458 rows=92 loops=1)

2. 0.090 28.446 ↑ 2.2 92 1

Unique (cost=8,311.48..8,325.18 rows=203 width=554) (actual time=28.340..28.446 rows=92 loops=1)

3. 0.127 28.356 ↑ 2.2 92 1

Sort (cost=8,311.48..8,311.99 rows=203 width=554) (actual time=28.339..28.356 rows=92 loops=1)

  • Sort Key: lima_delta1.quebec_seven, lima_delta1.juliet_delta, lima_delta1.oscar_four, lima_delta1.november_seven, lima_delta1.mike_seven, lima_delta1.foxtrot_bravo, lima_delta1.golf_echo, lima_delta1.zulu_alpha, lima_delta1.november_romeo, romeo_three1.three, romeo_three1.six_xray, kilo_foxtrot1.quebec_seven, kilo_foxtrot1.juliet_delta, kilo_foxtrot1.three, kilo_foxtrot2.quebec_seven, kilo_foxtrot2.juliet_delta, kilo_foxtrot2.three, alpha_seven1.three, alpha_seven1.yankee_tango, uniform_delta1.juliet_delta, uniform_delta1.three, papa_kilo1.whiskey_zulu, echo_seven1.victor_five, ((zulu_uniform1.oscar_sierra five_romeo NOT NULL)), (six_uniform(0, alpha_oscar1.six_uniform, lima_delta1.foxtrot_bravo, LOCALTIMESTAMP, lima_delta1.mike_seven)), ((six_uniform(1, alpha_oscar1.six_uniform, lima_delta1.foxtrot_bravo, LOCALTIMESTAMP, lima_delta1.mike_seven))::boolean)
  • Sort Method: quicksort Memory: 93kB
4. 2.195 28.229 ↑ 2.2 92 1

Nested Loop Left Join (cost=200.37..8,303.70 rows=203 width=554) (actual time=0.479..28.229 rows=92 loops=1)

  • Join Filter: (lima_delta1.juliet_hotel = india1.quebec_hotel)
5. 0.058 26.034 ↑ 2.2 92 1

Nested Loop Left Join (cost=200.37..8,196.06 rows=203 width=1,167) (actual time=0.393..26.034 rows=92 loops=1)

6. 0.063 25.884 ↑ 2.2 92 1

Nested Loop Left Join (cost=200.09..8,100.66 rows=203 width=500) (actual time=0.389..25.884 rows=92 loops=1)

7. 0.110 25.821 ↑ 2.2 92 1

Nested Loop (cost=199.81..8,040.77 rows=203 width=475) (actual time=0.387..25.821 rows=92 loops=1)

8. 0.087 25.619 ↑ 2.2 92 1

Nested Loop (cost=199.53..7,981.38 rows=203 width=414) (actual time=0.381..25.619 rows=92 loops=1)

9. 0.030 25.160 ↑ 2.2 93 1

Nested Loop (cost=199.10..7,468.24 rows=201 width=390) (actual time=0.373..25.160 rows=93 loops=1)

10. 0.009 0.009 ↑ 1.0 1 1

Index Scan using two_delta on echo_zulu mike_quebec (cost=0.27..2.49 rows=1 width=96) (actual time=0.008..0.009 rows=1 loops=1)

  • Index Cond: (quebec_seven = 81)
11. 0.046 25.121 ↑ 2.2 93 1

Nested Loop (cost=198.83..7,463.74 rows=201 width=294) (actual time=0.364..25.121 rows=93 loops=1)

12. 0.023 24.982 ↑ 2.2 93 1

Nested Loop (cost=198.69..7,433.09 rows=201 width=285) (actual time=0.361..24.982 rows=93 loops=1)

13. 0.087 24.680 ↑ 2.2 93 1

Nested Loop (cost=198.41..7,359.15 rows=201 width=274) (actual time=0.356..24.680 rows=93 loops=1)

14. 0.071 24.314 ↑ 2.2 93 1

Hash Join (cost=198.13..7,255.30 rows=209 width=223) (actual time=0.350..24.314 rows=93 loops=1)

  • Hash Cond: (lima_delta1.lima_echo = alpha_oscar1.uniform_bravo)
15. 23.950 23.950 ↑ 32.3 93 1

Index Scan using papa_yankee on foxtrot_romeo quebec_sierra (cost=0.56..7,049.84 rows=3,000 width=179) (actual time=0.052..23.950 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,905
16. 0.064 0.293 ↓ 1.0 352 1

Hash (cost=193.23..193.23 rows=347 width=52) (actual time=0.292..0.293 rows=352 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 65kB
17. 0.229 0.229 ↓ 1.0 352 1

Index Scan using five_victor on delta_alpha five_xray (cost=0.28..193.23 rows=347 width=52) (actual time=0.007..0.229 rows=352 loops=1)

  • Index Cond: (foxtrot_charlie = 81)
18. 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=67) (actual time=0.003..0.003 rows=1 loops=93)

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

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

  • Index Cond: (quebec_seven = lima_delta1.two_romeo)
20. 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=25) (actual time=0.001..0.001 rows=1 loops=93)

  • Index Cond: (quebec_seven = lima_delta1.four_sierra)
21. 0.372 0.372 ↑ 1.0 1 93

Index Scan using charlie on uniform_kilo victor_romeo (cost=0.43..2.54 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=93)

  • Index Cond: (sierra_foxtrot = lima_delta1.quebec_seven)
22. 0.092 0.092 ↑ 1.0 1 92

Index Scan using kilo_kilo on oscar_oscar yankee_xray (cost=0.28..0.29 rows=1 width=69) (actual time=0.001..0.001 rows=1 loops=92)

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

Index Scan using uniform_golf on whiskey_tango hotel_golf (cost=0.28..0.30 rows=1 width=41) (actual time=0.000..0.000 rows=0 loops=92)

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

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

  • Index Cond: (lima_delta1.quebec_seven = sierra_foxtrot)
25. 0.000 0.000 ↓ 0.0 0 92

Materialize (cost=0.00..1.06 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=92)

26. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on hotel_three romeo_foxtrot (cost=0.00..1.06 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: ((quebec_hotel = 81) AND ((juliet_charlie)::text = 'kilo_papa'::text))
  • Rows Removed by Filter: 4
Planning time : 12.995 ms
Execution time : 28.599 ms