explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fyFZ

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

Finalize Aggregate (cost=76,386.75..76,386.76 rows=1 width=8) (actual time=524.477..524.477 rows=1 loops=1)

2. 144.657 528.763 ↓ 1.5 3 1

Gather (cost=76,386.53..76,386.74 rows=2 width=8) (actual time=523.860..528.763 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 8.575 384.106 ↑ 1.0 1 3

Partial Aggregate (cost=75,386.53..75,386.54 rows=1 width=8) (actual time=384.106..384.106 rows=1 loops=3)

4. 375.531 375.531 ↑ 1.3 109,042 3

Parallel Seq Scan on nota_fiscal (cost=0.00..75,044.31 rows=136,888 width=0) (actual time=0.377..375.531 rows=109,042 loops=3)

  • Filter: (situacao = 'EM'::bpchar)
  • Rows Removed by Filter: 59355
Planning time : 0.222 ms