explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.004 23.574 ↑ 1.4 41 1

Limit (cost=7,126.28..7,126.43 rows=57 width=295) (actual time=23.565..23.574 rows=41 loops=1)

2. 0.022 23.570 ↑ 1.4 41 1

Sort (cost=7,126.28..7,126.43 rows=57 width=295) (actual time=23.564..23.570 rows=41 loops=1)

  • Sort Key: quebec_seven
  • Sort Method: quicksort Memory: 46kB
3. 23.548 23.548 ↑ 1.4 41 1

Index Scan using papa_yankee on foxtrot quebec_sierra (cost=0.56..7,124.62 rows=57 width=295) (actual time=0.074..23.548 rows=41 loops=1)

  • Index Cond: ((lima)::text = 'quebec_quebec'::text)
  • Filter: (((NOT papa_bravo) OR (papa_bravo five NULL)) AND (mike >= 'golf'::timestamp without time zone) AND (juliet = 81))
  • Rows Removed by Filter: 26,999
Planning time : 0.119 ms
Execution time : 23.601 ms