explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7qmN

Settings
# exclusive inclusive rows x rows loops node
1. 0.585 794.424 ↑ 1.0 1 1

Aggregate (cost=22,850.88..22,850.89 rows=1 width=8) (actual time=794.423..794.424 rows=1 loops=1)

2. 793.839 793.839 ↓ 52.4 2,775 1

Seq Scan on workflow_status (cost=0.00..22,850.74 rows=53 width=0) (actual time=0.023..793.839 rows=2,775 loops=1)

  • Filter: ((sla IS NOT NULL) AND (workflow_completed_time IS NULL) AND (workflow_failed_time IS NULL) AND (workflow_resolved_time IS NULL) AND ((workflow_group)::text = 'Escript'::text) AND ((workflow_name)::text = 'NotifyPharmacy'::text) AND ((now() - workflow_start_time) >= sla))
  • Rows Removed by Filter: 128,388
Planning time : 2.305 ms
Execution time : 794.511 ms