explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Aitr

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 676.023 ↑ 1.0 1 1

Finalize Aggregate (cost=72,501.02..72,501.03 rows=1 width=8) (actual time=676.023..676.023 rows=1 loops=1)

2. 68.093 676.013 ↓ 1.2 5 1

Gather (cost=72,500.60..72,501.01 rows=4 width=8) (actual time=675.937..676.013 rows=5 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 252.777 607.920 ↑ 1.0 1 5

Partial Aggregate (cost=71,500.60..71,500.61 rows=1 width=8) (actual time=607.920..607.920 rows=1 loops=5)

4. 355.143 355.143 ↑ 1.3 497,282 5

Parallel Seq Scan on consumption_entity ce (cost=0.00..69,946.50 rows=621,640 width=4) (actual time=0.017..355.143 rows=497,282 loops=5)

  • Filter: (client_id = 1007)
  • Rows Removed by Filter: 27