explain.depesz.com

PostgreSQL's explain analyze made readable

Result: elHgV : Optimization for: 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 #gWgH; plan #lj5Ms; plan #B8eq; plan #Yty9; plan #Lheu; plan #27c; plan #qUXb; plan #6xFD; plan #YOFp; plan #tvR9; plan #vDLc; plan #4jS3; plan #a2yB

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.013 26.409 ↑ 2.1 120 1

Limit (cost=7,396.63..7,397.25 rows=250 width=1,190) (actual time=26.377..26.409 rows=120 loops=1)

2. 0.171 26.396 ↑ 27.0 120 1

Sort (cost=7,396.63..7,404.73 rows=3,242 width=1,190) (actual time=26.376..26.396 rows=120 loops=1)

  • Sort Key: lima_delta1.mike_seven
  • Sort Method: quicksort Memory: 266kB
3. 0.068 26.225 ↑ 27.0 120 1

Hash Left Join (cost=79.58..7,251.29 rows=3,242 width=1,190) (actual time=0.292..26.225 rows=120 loops=1)

  • Hash Cond: (lima_delta1.juliet_hotel = uniform1.quebec_seven)
4. 0.427 25.944 ↑ 27.0 120 1

Hash Left Join (cost=1.65..7,164.76 rows=3,242 width=518) (actual time=0.074..25.944 rows=120 loops=1)

  • Hash Cond: (lima_delta1.juliet_hotel = india1.quebec_hotel)
  • Filter: ((lima_delta1.juliet_hotel = 81) OR (india1.yankee = 81))
  • Rows Removed by Filter: 3,738
5. 25.507 25.507 ↑ 2.6 3,858 1

Index Scan using papa_yankee on foxtrot quebec_sierra (cost=0.56..7,124.62 rows=9,970 width=295) (actual time=0.038..25.507 rows=3,858 loops=1)

  • Index Cond: ((lima_romeo)::text = 'quebec_quebec'::text)
  • Filter: (((NOT papa_bravo) OR (papa_bravo five NULL)) AND ((mike_seven)::date >= 'four'::date))
  • Rows Removed by Filter: 23,335
6. 0.003 0.010 ↑ 1.0 3 1

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

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

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

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

Hash (cost=72.97..72.97 rows=397 width=664) (actual time=0.212..0.213 rows=397 loops=1)

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

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

Planning time : 0.401 ms
Execution time : 26.618 ms