explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RIOj

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.007 39.395 ↑ 1.0 1 1

Limit (cost=8,487.03..8,487.03 rows=1 width=18) (actual time=39.394..39.395 rows=1 loops=1)

2. 0.266 39.388 ↑ 4.2 101 1

Sort (cost=8,486.78..8,487.85 rows=429 width=18) (actual time=39.381..39.388 rows=101 loops=1)

  • Sort Key: logstarttime
  • Sort Method: top-N heapsort Memory: 34kB
3. 39.122 39.122 ↓ 2.2 945 1

Seq Scan on attributemap (cost=0.00..8,470.35 rows=429 width=18) (actual time=0.007..39.122 rows=945 loops=1)

  • Filter: ((NOT uploaded) AND (destination = 'default_log_store'::text))
  • Rows Removed by Filter: 137,987
Planning time : 0.062 ms
Execution time : 39.412 ms