explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mr8

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 792.734 ↑ 1.0 1 1

Finalize Aggregate (cost=72,489.89..72,489.90 rows=1 width=8) (actual time=792.734..792.734 rows=1 loops=1)

2. 375.483 792.728 ↓ 1.2 5 1

Gather (cost=72,489.48..72,489.88 rows=4 width=8) (actual time=792.704..792.728 rows=5 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 133.468 417.245 ↑ 1.0 1 5

Partial Aggregate (cost=71,489.48..71,489.49 rows=1 width=8) (actual time=417.245..417.245 rows=1 loops=5)

4. 283.777 283.777 ↑ 1.2 494,683 5

Parallel Seq Scan on consumption_entity ce (cost=0.00..69,946.50 rows=617,190 width=4) (actual time=0.018..283.777 rows=494,683 loops=5)

  • Filter: ((NOT deleted) AND (NOT saved_as_draft) AND (client_id = 1007))
  • Rows Removed by Filter: 2625