explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FTGa : sidcee

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

HashAggregate (cost=924,981.47..926,267.02 rows=14,692 width=520) (actual rows= loops=)

  • Group Key: deed_dmde_cee.cde_dmd, CASE deed_dmde_cee.cde_per WHEN 1 THEN 'Période 2 de 2010 à 2014 '::text WHEN 2 THEN 'Période 3 de 2015 à 2017'::text WHEN 3 THEN 'Période 4 de 2018 à 2020'::text ELSE NULL::text END, CASE deed_dmde_cee.kbs WHEN 'Y'::text THEN 'O'::text WHEN 'N'::text THEN 'N'::text WHEN '0'::text THEN '0'::text ELSE NULL::text END, CASE deed_dmde_cee.opr_prg WHEN 'Y'::text THEN 'O'::text WHEN 'N'::text THEN 'N'::text WHEN '0'::text THEN '0'::text ELSE NULL::text END, CASE deed_dmde_cee.opr_std WHEN 'Y'::text THEN 'O'::text WHEN 'N'::text THEN 'N'::text WHEN '0'::text THEN '0'::text ELSE NULL::text END, CASE deed_dmde_cee.opr_spe WHEN 'Y'::text THEN 'O'::text WHEN 'N'::text THEN 'N'::text WHEN '0'::text THEN '0'::text ELSE NULL::text END, CASE deed_dmde_cee.dos_pap_emy WHEN 'Y'::text THEN 'O'::text WHEN 'N'::text THEN 'N'::text WHEN '0'::text THEN '0'::text ELSE NULL::text END, CASE deed_dmde_cee.mnd WHEN 'Y'::text THEN 'O'::text WHEN 'N'::text THEN 'N'::text WHEN '0'::text THEN '0'::text ELSE NULL::text END, CASE deed_dmde_cee.drg_sig WHEN 'Y'::text THEN 'O'::text WHEN 'N'::text THEN 'N'::text WHEN '0'::text THEN '0'::text ELSE NULL::text END, CASE deed_dmde_cee.dos_dmn_pae WHEN 'Y'::text THEN 'O'::text WHEN 'N'::text THEN 'N'::text WHEN '0'::text THEN '0'::text ELSE NULL::text END, CASE deed_dmde_cee.rgp_dmr_cee WHEN 'Y'::text THEN 'O'::text WHEN 'N'::text THEN 'N'::text WHEN '0'::text THEN '0'::text ELSE NULL::text END
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,318.57..738,405.26 rows=6,219,207 width=493) (actual rows= loops=)

  • Hash Cond: (deef_sui_opr.cde_dmd = deed_dmde_cee.cde_dmd)
3. 0.000 0.000 ↓ 0.0

Seq Scan on deef_sui_opr (cost=0.00..185,132.07 rows=6,219,207 width=13) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=1,134.92..1,134.92 rows=14,692 width=194) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on deed_dmde_cee (cost=0.00..1,134.92 rows=14,692 width=194) (actual rows= loops=)