explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0fS2 : req delete 1

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 7.084 9,088.155 ↓ 0.0 0 1

Delete on histo_routeur_intranet (cost=0.00..1,041,858.90 rows=2,887 width=6) (actual time=9,088.155..9,088.155 rows=0 loops=1)

2. 9,081.071 9,081.071 ↓ 3.2 9,213 1

Seq Scan on histo_routeur_intranet (cost=0.00..1,041,858.90 rows=2,887 width=6) (actual time=0.033..9,081.071 rows=9,213 loops=1)

  • Filter: ((feuillet)::text = 'CD015W2ECE'::text)
  • Rows Removed by Filter: 37048916