explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LmWX

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 155.629 ↑ 1.0 1 1

Aggregate (cost=46,020.13..46,020.14 rows=1 width=8) (actual time=155.628..155.629 rows=1 loops=1)

2. 125.535 155.624 ↓ 0.0 0 1

Bitmap Heap Scan on workflow_status (cost=6,116.59..46,019.91 rows=91 width=0) (actual time=155.624..155.624 rows=0 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: 346,168
  • Heap Blocks: exact=30,974
3. 30.089 30.089 ↓ 1.6 346,169 1

Bitmap Index Scan on idx_workflow_name_group (cost=0.00..6,116.57 rows=210,414 width=0) (actual time=30.088..30.089 rows=346,169 loops=1)

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