explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.007 21.455 ↑ 2.7 93 1

Limit (cost=7,184.33..7,184.96 rows=250 width=295) (actual time=21.436..21.455 rows=93 loops=1)

2. 0.053 21.448 ↑ 32.3 93 1

Sort (cost=7,184.33..7,191.83 rows=3,000 width=295) (actual time=21.435..21.448 rows=93 loops=1)

  • Sort Key: quebec_seven
  • Sort Method: quicksort Memory: 72kB
3. 21.395 21.395 ↑ 32.3 93 1

Index Scan using papa_yankee on foxtrot quebec_sierra (cost=0.56..7,049.84 rows=3,000 width=295) (actual time=0.069..21.395 rows=93 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,944
Planning time : 0.117 ms
Execution time : 21.481 ms