explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FaGg

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 174.857 ↑ 1.0 1,000 1

Limit (cost=33,033.32..33,035.82 rows=1,000 width=175) (actual time=174.727..174.857 rows=1,000 loops=1)

2. 10.724 174.818 ↑ 77.9 1,000 1

Sort (cost=33,033.32..33,228.12 rows=77,921 width=175) (actual time=174.725..174.818 rows=1,000 loops=1)

  • Sort Key: dateadded
  • Sort Method: top-N heapsort Memory: 354kB
3. 164.094 164.094 ↓ 1.3 101,044 1

Seq Scan on attachment (cost=0.00..28,760.99 rows=77,921 width=175) (actual time=0.022..164.094 rows=101,044 loops=1)

  • Filter: ((NOT isarchived) AND ((roadworkrequesttypeid IS NOT NULL) OR (permitid IS NOT NULL) OR (projectid IS NOT NULL) OR (projectpreparationid IS NOT NULL)) AND (dateadded <= (now() + '3 days'::interval)))
  • Rows Removed by Filter: 779527