explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OoMW

Settings
# exclusive inclusive rows x rows loops node
1. 0.589 181.508 ↑ 1.0 1 1

Aggregate (cost=8,049.53..8,049.54 rows=1 width=8) (actual time=181.507..181.508 rows=1 loops=1)

2. 82.295 180.919 ↓ 53.1 2,867 1

Bitmap Heap Scan on workflow_status (cost=89.76..8,049.40 rows=54 width=0) (actual time=100.357..180.919 rows=2,867 loops=1)

  • Recheck Cond: (((workflow_name)::text = 'NotifyPharmacy'::text) AND ((workflow_group)::text = 'Escript'::text))
  • Filter: ((sla IS NOT NULL) AND (workflow_completed_time IS NULL) AND (workflow_failed_time IS NULL) AND (workflow_resolved_time IS NULL) AND ((now() - workflow_start_time) >= sla))
  • Rows Removed by Filter: 8,948
  • Heap Blocks: exact=1,867
3. 98.624 98.624 ↓ 4.0 11,815 1

Bitmap Index Scan on idx_workflow_name_group (cost=0.00..89.75 rows=2,933 width=0) (actual time=98.623..98.624 rows=11,815 loops=1)

  • Index Cond: (((workflow_name)::text = 'NotifyPharmacy'::text) AND ((workflow_group)::text = 'Escript'::text))
Planning time : 60.455 ms
Execution time : 181.560 ms