explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3B7m : Optimization for: Optimization for: plan #XHT8; plan #VT6p

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.008 23.451 ↑ 2.7 94 1

Limit (cost=7,191.83..7,192.46 rows=250 width=299) (actual time=23.434..23.451 rows=94 loops=1)

2. 0.102 23.443 ↑ 31.9 94 1

Sort (cost=7,191.83..7,199.33 rows=3,000 width=299) (actual time=23.433..23.443 rows=94 loops=1)

  • Sort Key: ((mike)::date)
  • Sort Method: quicksort Memory: 73kB
3. 23.341 23.341 ↑ 31.9 94 1

Index Scan using papa_yankee on foxtrot quebec_sierra (cost=0.56..7,057.34 rows=3,000 width=299) (actual time=0.024..23.341 rows=94 loops=1)

  • Index Cond: ((lima)::text = 'quebec_quebec'::text)
  • Filter: (((NOT papa_bravo) OR (papa_bravo five NULL)) AND (juliet = 81))
  • Rows Removed by Filter: 26,942
Planning time : 0.110 ms
Execution time : 23.510 ms