explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MrYx

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

Limit (cost=12.08..63.77 rows=1 width=18) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12.08..63.77 rows=1 width=18) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on cdcentete e (cost=11.52..15.53 rows=1 width=18) (actual rows= loops=)

  • Recheck Cond: ((cdce_idliv = '1Dhy1C7KhvkL5hA81'::bpchar) AND (cdce_idcli = '1Dhy1C26bRHaL4hA8'::bpchar))
  • Filter: (cdce_etat IS NULL)
4. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=11.52..11.52 rows=1 width=0) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ix_cd_adre_cdce_ad (cost=0.00..5.38 rows=127 width=0) (actual rows= loops=)

  • Index Cond: (cdce_idliv = '1Dhy1C7KhvkL5hA81'::bpchar)
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ix_cdce_repe_idcli (cost=0.00..5.88 rows=194 width=0) (actual rows= loops=)

  • Index Cond: (cdce_idcli = '1Dhy1C26bRHaL4hA8'::bpchar)
7. 0.000 0.000 ↓ 0.0

Index Scan using cdcdetailp_prep3 on cdcdetailp p (cost=0.56..48.20 rows=4 width=18) (actual rows= loops=)

  • Index Cond: ((cdcp_etat IS NULL) AND (cdcp_etali = 'E'::bpchar) AND (cdce_id = e.cdce_id))
  • Filter: ((cdcp_factu IS NULL) OR (cdcp_factu = 0))