explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hhgt

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 88.726 ↑ 1.0 1 1

Finalize Aggregate (cost=20,108.01..20,108.02 rows=1 width=8) (actual time=88.726..88.726 rows=1 loops=1)

2. 16.335 88.775 ↓ 1.5 3 1

Gather (cost=20,107.79..20,108.00 rows=2 width=8) (actual time=83.757..88.775 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.003 72.440 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=19,107.79..19,107.80 rows=1 width=8) (actual time=72.440..72.440 rows=1 loops=3)

4. 72.437 72.437 ↓ 0.0 0 3 / 3

Parallel Seq Scan on manual_review_events (cost=0.00..19,107.79 rows=2 width=0) (actual time=72.437..72.437 rows=0 loops=3)

  • Filter: ((resolution_action IS NULL) AND ((workflow_group)::text = 'Escript'::text) AND ((workflow_name)::text = 'Claim'::text))
  • Rows Removed by Filter: 73,138
Planning time : 0.083 ms
Execution time : 88.819 ms