explain.depesz.com

PostgreSQL's explain analyze made readable

Result: onPS

Settings
# exclusive inclusive rows x rows loops node
1. 0.058 0.576 ↑ 1.0 1 1

Bitmap Heap Scan on contentitem ci (cost=240.85..317.40 rows=1 width=4) (actual time=0.545..0.576 rows=1 loops=1)

  • Recheck Cond: (contentmoduleid = 9)
  • Filter: ((applicationid = 1) AND (organisationid = 1) AND (languageid = 1) AND (lower((key)::text) = 'lblrequesthistory'::text))
  • Rows Removed by Filter: 66
  • Heap Blocks: exact=14
2. 0.518 0.518 ↓ 2.0 67 1

Bitmap Index Scan on ix_dks (cost=0.00..240.85 rows=33 width=0) (actual time=0.518..0.518 rows=67 loops=1)

  • Index Cond: (contentmoduleid = 9)