explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T3Kj

Settings
# exclusive inclusive rows x rows loops node
1. 0.041 85.987 ↑ 1.0 1,000 1

Limit (cost=0.43..616.76 rows=1,000 width=175) (actual time=85.313..85.987 rows=1,000 loops=1)

2. 85.946 85.946 ↑ 77.9 1,000 1

Index Scan using ix_dks on attachment (cost=0.43..48,030.14 rows=77,929 width=175) (actual time=85.312..85.946 rows=1,000 loops=1)

  • Index Cond: ((dateadded <= (now() + '3 days'::interval)) AND (isarchived = false))
  • Filter: ((NOT isarchived) AND ((roadworkrequesttypeid IS NOT NULL) OR (permitid IS NOT NULL) OR (projectid IS NOT NULL) OR (projectpreparationid IS NOT NULL)))