explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.018 99.083 ↑ 1.5 169 1

Limit (cost=7,323.16..7,323.78 rows=250 width=1,190) (actual time=99.040..99.083 rows=169 loops=1)

2. 0.318 99.065 ↑ 18.7 169 1

Sort (cost=7,323.16..7,331.07 rows=3,164 width=1,190) (actual time=99.039..99.065 rows=169 loops=1)

  • Sort Key: lima_delta1.quebec_seven
  • Sort Method: quicksort Memory: 365kB
3. 0.175 98.747 ↑ 18.7 169 1

Hash Left Join (cost=79.58..7,181.32 rows=3,164 width=1,190) (actual time=0.348..98.747 rows=169 loops=1)

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

Hash Left Join (cost=1.65..7,094.99 rows=3,164 width=518) (actual time=0.055..98.285 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,621
5. 94.465 94.465 ↑ 1.7 17,790 1

Index Scan using papa_yankee on foxtrot quebec_sierra (cost=0.56..6,975.07 rows=29,909 width=295) (actual time=0.031..94.465 rows=17,790 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.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.140 0.287 ↑ 1.0 397 1

Hash (cost=72.97..72.97 rows=397 width=664) (actual time=0.286..0.287 rows=397 loops=1)

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

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

Planning time : 0.721 ms
Execution time : 99.337 ms