explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Osvd

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.251 ↑ 1.0 1 1

Aggregate (cost=10.73..10.74 rows=1 width=8) (actual time=0.251..0.251 rows=1 loops=1)

2. 0.249 0.249 ↓ 0.0 0 1

Index Scan using idx_workflow on manual_review_events (cost=0.42..10.72 rows=2 width=0) (actual time=0.249..0.249 rows=0 loops=1)

  • Index Cond: (((workflow_name)::text = 'NotifyPharmacy'::text) AND ((workflow_group)::text = 'Escript'::text))
  • Filter: (resolution_action IS NULL)
  • Rows Removed by Filter: 238
Planning time : 0.150 ms
Execution time : 0.281 ms