explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tXEa

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,578.988 ↓ 0.0 0 1

Nested Loop (cost=353,990.67..1,278,507.69 rows=1 width=4) (actual time=1,578.988..1,578.988 rows=0 loops=1)

  • Output: vcligne.vcligne_id
  • Inner Unique: true
2. 929.317 1,578.988 ↓ 0.0 0 1

Bitmap Heap Scan on public.vcligne (cost=353,990.24..1,278,499.23 rows=1 width=12) (actual time=1,578.988..1,578.988 rows=0 loops=1)

  • Output: vcligne.vcligne_id, vcligne.vcligne_vcentete_id, vcligne.vcligne_dossier_id
  • Recheck Cond: ((vcligne.vcligne_dossier_id = 246) AND (vcligne.vcligne_date >= '2019-07-15 00:00:00'::timestamp without time zone) AND (vcligne.vcligne_date <= '9999-12-31 00:00:00'::timestamp without time zone) AND ((vcligne.vcligne_dossier)::text = 'VVE_VERGERS_CHALLANS'::text))
  • Rows Removed by Index Recheck: 328,068
  • Filter: ((vcligne.vcligne_articleidstd = 3,830,967) AND ((vcligne.vcligne_etatmarge)::text <> ALL ('{Manuelle,Promo,Close}'::text[])))
  • Rows Removed by Filter: 1,361,449
  • Heap Blocks: exact=139,627 lossy=87,591
3. 649.671 649.671 ↓ 4.9 1,361,456 1

Bitmap Index Scan on vcligne_date_sk (cost=0.00..353,990.23 rows=276,687 width=0) (actual time=649.671..649.671 rows=1,361,456 loops=1)

  • Index Cond: ((vcligne.vcligne_dossier_id = 246) AND (vcligne.vcligne_date >= '2019-07-15 00:00:00'::timestamp without time zone) AND (vcligne.vcligne_date <= '9999-12-31 00:00:00'::timestamp without time zone) AND ((vcligne.vcligne_dossier)::text = 'VVE_VERGERS_CHALLANS'::text))
4. 0.000 0.000 ↓ 0.0 0

Index Scan using vcentete_pk on public.vcentete (cost=0.43..8.46 rows=1 width=8) (never executed)

  • Output: vcentete.vcentete_id, vcentete.vcentete_dossier_id
  • Index Cond: (vcentete.vcentete_id = vcligne.vcligne_vcentete_id)
  • Filter: ((vcentete.vcentete_dossier_id = 246) AND ((vcentete.vcentete_depotcode)::text = '2CHAL'::text))