explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vxl

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

Finalize Aggregate (cost=76,044.53..76,044.54 rows=1 width=8) (actual time=445.070..445.071 rows=1 loops=1)

2. 104.127 454.738 ↓ 1.5 3 1

Gather (cost=76,044.31..76,044.52 rows=2 width=8) (actual time=444.599..454.738 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 12.802 350.611 ↑ 1.0 1 3

Partial Aggregate (cost=75,044.31..75,044.32 rows=1 width=8) (actual time=350.611..350.611 rows=1 loops=3)

4. 337.809 337.809 ↑ 1.2 168,397 3

Parallel Seq Scan on nota_fiscal (cost=0.00..74,518.25 rows=210,425 width=0) (actual time=0.148..337.809 rows=168,397 loops=3)

Planning time : 1.970 ms