explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qEWJ

Settings
# exclusive inclusive rows x rows loops node
1. 464.873 127,706.664 ↓ 1.1 1,502,722 1

Gather (cost=1,000.00..3,758,302.16 rows=1,407,241 width=10) (actual time=2.340..127,706.664 rows=1,502,722 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 127,241.791 127,241.791 ↑ 1.2 500,907 3 / 3

Parallel Seq Scan on "fm_Ventes" (cost=0.00..3,616,578.06 rows=586,350 width=10) (actual time=15.195..127,241.791 rows=500,907 loops=3)

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