explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sVTv

Settings
# exclusive inclusive rows x rows loops node
1. 498.436 121,610.092 ↓ 1.0 1,502,722 1

Gather (cost=1,000.00..3,766,549.88 rows=1,494,350 width=10) (actual time=2.502..121,610.092 rows=1,502,722 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 121,111.656 121,111.656 ↑ 1.2 500,907 3 / 3

Parallel Seq Scan on "fm_Ventes" (cost=0.00..3,616,114.88 rows=622,646 width=10) (actual time=10.040..121,111.656 rows=500,907 loops=3)

  • Filter: (("s_Code_Avancement")::text <> 'T'::text)
  • Rows Removed by Filter: 12587738
Planning time : 28.786 ms