explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FPFV

Settings
# exclusive inclusive rows x rows loops node
1. 0.044 0.875 ↑ 1.0 1,000 1

Limit (cost=0.43..680.48 rows=1,000 width=175) (actual time=0.144..0.875 rows=1,000 loops=1)

2. 0.831 0.831 ↑ 75.9 1,000 1

Index Scan using ix_dks on attachment (cost=0.43..51,630.77 rows=75,921 width=175) (actual time=0.143..0.831 rows=1,000 loops=1)

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