explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rz4X

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 56,441.673 ↑ 1.0 1 1

Finalize Aggregate (cost=532,377.24..532,377.25 rows=1 width=8) (actual time=56,441.673..56,441.673 rows=1 loops=1)

2. 4.774 56,441.764 ↓ 1.5 3 1

Gather (cost=532,377.02..532,377.23 rows=2 width=8) (actual time=56,441.063..56,441.764 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,258.945 56,436.990 ↑ 1.0 1 3

Partial Aggregate (cost=531,377.02..531,377.03 rows=1 width=8) (actual time=56,436.989..56,436.990 rows=1 loops=3)

4. 55,178.045 55,178.045 ↑ 1.3 5,339,687 3

Parallel Seq Scan on report_analytic_portfolio (cost=0.00..514,439.82 rows=6,774,882 width=0) (actual time=1.111..55,178.045 rows=5,339,687 loops=3)