explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7UwA

Settings
# exclusive inclusive rows x rows loops node
1. 0.075 70.246 ↑ 1.0 1 1

Aggregate (cost=136,621.70..136,621.71 rows=1 width=8) (actual time=70.245..70.246 rows=1 loops=1)

  • Buffers: shared hit=19990
2. 0.084 70.171 ↓ 3.2 910 1

Result (cost=1,208.44..136,620.98 rows=288 width=0) (actual time=69.515..70.171 rows=910 loops=1)

  • One-Time Filter: ('2020-05-04 00:00:00-04'::timestamp with time zone > (now() - '64 days'::interval))
  • Buffers: shared hit=19990
3. 58.833 70.087 ↓ 3.2 910 1

Bitmap Heap Scan on proposalworkflowstatus pws (cost=1,208.44..136,620.98 rows=288 width=0) (actual time=69.511..70.087 rows=910 loops=1)

  • Recheck Cond: ((workflowstatusid = ANY ('{1,5}'::integer[])) AND (usercreated = 2392881))
  • Filter: (date_trunc('week'::text, datecreated) = '2020-05-04 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 149375
  • Heap Blocks: exact=19571
  • Buffers: shared hit=19990
4. 11.254 11.254 ↓ 2.6 150,285 1

Bitmap Index Scan on proposalworkflowstatus_workflowstatusid_usercreated (cost=0.00..1,208.37 rows=57,525 width=0) (actual time=11.254..11.254 rows=150,285 loops=1)

  • Index Cond: ((workflowstatusid = ANY ('{1,5}'::integer[])) AND (usercreated = 2392881))
  • Buffers: shared hit=419