explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gUcY

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,346.631 ↑ 1.0 1 1

Finalize Aggregate (cost=258,261.54..258,261.55 rows=1 width=8) (actual time=2,346.631..2,346.631 rows=1 loops=1)

  • Functions: 8
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 77.663 ms, Inlining 0.000 ms, Optimization 10.457 ms, Emission 245.711 ms, Total 333.832 ms
2. 508.023 2,371.831 ↓ 1.5 3 1

Gather (cost=258,261.32..258,261.53 rows=2 width=8) (actual time=2,346.063..2,371.831 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 609.149 1,863.808 ↑ 1.0 1 3

Partial Aggregate (cost=257,261.32..257,261.33 rows=1 width=8) (actual time=1,863.808..1,863.808 rows=1 loops=3)

4. 1,254.659 1,254.659 ↑ 1.2 4,057,751 3

Parallel Seq Scan on ciqcompany (cost=0.00..244,595.26 rows=5,066,426 width=0) (actual time=0.070..1,254.659 rows=4,057,751 loops=3)

Planning time : 0.177 ms