explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lZLW

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

HashAggregate (cost=183,023.54..189,878.94 rows=548,432 width=38) (actual rows= loops=)

  • Group Key: dm_f_dma_m2_adhesions.dma_niben
2. 0.000 0.000 ↓ 0.0

Result (cost=0.43..164,803.88 rows=3,643,933 width=10) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Append (cost=0.43..128,364.54 rows=3,643,933 width=10) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using inp_dma_dtref_m2 on dm_f_dma_m2_adhesions (cost=0.43..0.65 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (dma_dtreference_debut = to_date('2019-01-01'::text, 'YYYY-MM-DD'::text))
5. 0.000 0.000 ↓ 0.0

Seq Scan on dm_f_dma_m3_adhesions (cost=0.00..63,797.08 rows=1 width=10) (actual rows= loops=)

  • Filter: (dma_dtreference_debut = to_date('2019-01-01'::text, 'YYYY-MM-DD'::text))
6. 0.000 0.000 ↓ 0.0

Seq Scan on dm_f_dma_m1_adhesions (cost=0.00..64,566.81 rows=3,643,931 width=10) (actual rows= loops=)

  • Filter: (dma_dtreference_debut = to_date('2019-01-01'::text, 'YYYY-MM-DD'::text))