explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.013 29.459 ↑ 1.5 169 1

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

2. 0.269 29.446 ↑ 18.7 169 1

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

  • Sort Key: lima_delta1.mike_seven
  • Sort Method: quicksort Memory: 365kB
3. 0.134 29.177 ↑ 18.7 169 1

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

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

Hash Left Join (cost=1.65..7,094.99 rows=3,164 width=518) (actual time=0.053..28.765 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. 26.212 26.212 ↑ 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.030..26.212 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.139 0.278 ↑ 1.0 397 1

Hash (cost=72.97..72.97 rows=397 width=664) (actual time=0.277..0.278 rows=397 loops=1)

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

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

Planning time : 0.599 ms
Execution time : 29.658 ms