explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6xFD : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #gWgH; plan #lj5Ms; plan #B8eq; plan #Yty9; plan #Lheu; plan #27c; plan #qUXb

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.016 29.288 ↑ 1.5 169 1

Limit (cost=7,323.16..7,323.78 rows=250 width=1,198) (actual time=29.249..29.288 rows=169 loops=1)

2. 0.273 29.272 ↑ 18.7 169 1

Sort (cost=7,323.16..7,331.07 rows=3,164 width=1,198) (actual time=29.248..29.272 rows=169 loops=1)

  • Sort Key: lima_delta1.mike_seven, lima_delta1.november
  • Sort Method: quicksort Memory: 365kB
3. 0.136 28.999 ↑ 18.7 169 1

Hash Left Join (cost=79.58..7,181.32 rows=3,164 width=1,198) (actual time=0.234..28.999 rows=169 loops=1)

  • Hash Cond: (lima_delta1.juliet_hotel = uniform1.quebec_seven)
4. 2.222 28.667 ↑ 18.7 169 1

Hash Left Join (cost=1.65..7,094.99 rows=3,164 width=518) (actual time=0.035..28.667 rows=169 loops=1)

  • Hash Cond: (lima_delta1.juliet_hotel = india1.quebec_hotel)
  • Filter: (((lima_delta1.juliet_hotel = 81) OR (india1.yankee = 81)) AND ((lima_delta1.juliet_hotel = 81) OR (india1.yankee = 81)))
  • Rows Removed by Filter: 17,620
5. 26.437 26.437 ↑ 1.7 17,789 1

Index Scan using papa_yankee on foxtrot quebec_sierra (cost=0.56..6,975.07 rows=29,909 width=295) (actual time=0.020..26.437 rows=17,789 loops=1)

  • Index Cond: ((lima_romeo)::text = 'quebec_quebec'::text)
  • Filter: ((NOT papa_bravo) OR (papa_bravo five NULL))
  • Rows Removed by Filter: 9,402
6. 0.002 0.008 ↑ 1.0 3 1

Hash (cost=1.05..1.05 rows=3 width=223) (actual time=0.008..0.008 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.006 0.006 ↑ 1.0 3 1

Seq Scan on hotel romeo (cost=0.00..1.05 rows=3 width=223) (actual time=0.004..0.006 rows=3 loops=1)

  • Filter: ((juliet_charlie)::text = 'kilo'::text)
  • Rows Removed by Filter: 1
8. 0.086 0.196 ↑ 1.0 397 1

Hash (cost=72.97..72.97 rows=397 width=664) (actual time=0.195..0.196 rows=397 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 282kB
9. 0.110 0.110 ↑ 1.0 397 1

Seq Scan on echo mike_quebec (cost=0.00..72.97 rows=397 width=664) (actual time=0.003..0.110 rows=397 loops=1)

Planning time : 0.519 ms
Execution time : 29.496 ms