explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a2yB : 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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.009 25.824 ↑ 2.0 122 1

Limit (cost=7,396.63..7,397.25 rows=250 width=1,190) (actual time=25.799..25.824 rows=122 loops=1)

2. 0.148 25.815 ↑ 26.6 122 1

Sort (cost=7,396.63..7,404.73 rows=3,242 width=1,190) (actual time=25.798..25.815 rows=122 loops=1)

  • Sort Key: lima_delta1.mike_seven
  • Sort Method: quicksort Memory: 270kB
3. 0.069 25.667 ↑ 26.6 122 1

Hash Left Join (cost=79.58..7,251.29 rows=3,242 width=1,190) (actual time=0.259..25.667 rows=122 loops=1)

  • Hash Cond: (lima_delta1.juliet_hotel = uniform1.quebec_seven)
4. 0.697 25.394 ↑ 26.6 122 1

Hash Left Join (cost=1.65..7,164.76 rows=3,242 width=518) (actual time=0.051..25.394 rows=122 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: 6,894
5. 24.689 24.689 ↑ 1.4 7,016 1

Index Scan using papa_yankee on foxtrot quebec_sierra (cost=0.56..7,124.62 rows=9,970 width=295) (actual time=0.022..24.689 rows=7,016 loops=1)

  • Index Cond: ((lima_romeo)::text = 'quebec_quebec'::text)
  • Filter: (((NOT papa_bravo) OR (papa_bravo five NULL)) AND ((mike_seven)::date >= 'golf'::date))
  • Rows Removed by Filter: 20,177
6. 0.002 0.008 ↑ 1.0 3 1

Hash (cost=1.05..1.05 rows=3 width=223) (actual time=0.007..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.092 0.204 ↑ 1.0 397 1

Hash (cost=72.97..72.97 rows=397 width=664) (actual time=0.203..0.204 rows=397 loops=1)

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

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

Planning time : 0.407 ms
Execution time : 25.978 ms