explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QO0a

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 302.330 ↑ 1.0 1,000 1

Limit (cost=0.42..556.63 rows=1,000 width=175) (actual time=301.690..302.330 rows=1,000 loops=1)

2. 302.303 302.303 ↑ 77.9 1,000 1

Index Scan using pk_roadworkrequestattachment on attachment (cost=0.42..43,340.35 rows=77,921 width=175) (actual time=301.689..302.303 rows=1,000 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