explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wPpg

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 69,030.141 ↓ 0.0 0 1

Limit (cost=17.32..5,960.10 rows=1,000 width=438) (actual time=69,030.141..69,030.141 rows=0 loops=1)

  • Output: ((t_json_sal_xli.json_xli ->> 'type_SLI_TLI'::text)), ((t_json_sal_xli.json_xli ->> 'numeroMaree_ESPE_MR'::text)), ((t_json_sal_xli.json_xli ->> 'portDeVente_XLI_SL'::text)), ((t_json_sal_xli.json_xli ->> 'portDeDebarquement_SRC_PO'::text)), ((t_json_sal_xli.json_xli ->> 'dateDeDebarquement_SRC_DL'::text)), ((t_json_sal_xli.json_xli ->> 'dateDeVente_XLI_DA'::text)), ((t_json_sal_xli.json_xli ->> 'heureDeVente_ESLI_TI'::text)), ((t_json_sal_spe.json_xli_css_spe ->> 'espece_SPE_SN'::text)), ((t_json_sal_spe.json_xli_css_spe ->> 'espece_SPE_WT'::text)), ((t_json_sal_spe.json_xli_css_spe ->> 'espece_SPE_GE'::text)), ((t_json_sal_spe.json_xli_css_spe ->> 'espece_SPE_PRO_PR'::text)), ((t_json_sal_spe.json_xli_css_spe ->> 'espece_SPE_PRO_FF'::text))
2. 6,388.313 69,030.138 ↓ 0.0 0 1

Nested Loop (cost=17.32..42,125,797.65 rows=7,088,568 width=438) (actual time=69,030.138..69,030.138 rows=0 loops=1)

  • Output: (t_json_sal_xli.json_xli ->> 'type_SLI_TLI'::text), (t_json_sal_xli.json_xli ->> 'numeroMaree_ESPE_MR'::text), (t_json_sal_xli.json_xli ->> 'portDeVente_XLI_SL'::text), (t_json_sal_xli.json_xli ->> 'portDeDebarquement_SRC_PO'::text), (t_json_sal_xli.json_xli ->> 'dateDeDebarquement_SRC_DL'::text), (t_json_sal_xli.json_xli ->> 'dateDeVente_XLI_DA'::text), (t_json_sal_xli.json_xli ->> 'heureDeVente_ESLI_TI'::text), (t_json_sal_spe.json_xli_css_spe ->> 'espece_SPE_SN'::text), (t_json_sal_spe.json_xli_css_spe ->> 'espece_SPE_WT'::text), (t_json_sal_spe.json_xli_css_spe ->> 'espece_SPE_GE'::text), (t_json_sal_spe.json_xli_css_spe ->> 'espece_SPE_PRO_PR'::text), (t_json_sal_spe.json_xli_css_spe ->> 'espece_SPE_PRO_FF'::text)
3. 6,051.635 48,464.689 ↑ 1.0 7,088,568 1

Merge Join (cost=16.89..907,102.09 rows=7,088,568 width=442) (actual time=0.066..48,464.689 rows=7,088,568 loops=1)

  • Output: t_json_sal_xli.json_xli, t_json_sal_xli.xmlf_flux_cdn, t_json_sal_spe.json_xli_css_spe
  • Merge Cond: (t_json_sal_xli.t_json_sal_xli_cdn = t_json_sal_spe.t_json_sal_xli_cdn)
4. 32,917.796 32,917.796 ↑ 1.0 7,116,318 1

Index Scan using pk_t_json_sal_xli on ers3.t_json_sal_xli (cost=0.43..449,579.20 rows=7,116,318 width=280) (actual time=0.026..32,917.796 rows=7,116,318 loops=1)

  • Output: t_json_sal_xli.t_json_sal_xli_cdn, t_json_sal_xli.json_xli, t_json_sal_xli.xmlf_flux_cdn
5. 9,495.258 9,495.258 ↑ 1.0 7,088,568 1

Index Scan using i_t_json_sal_spe_sal_xli_cdn on ers3.t_json_sal_spe (cost=0.43..351,149.95 rows=7,088,568 width=170) (actual time=0.015..9,495.258 rows=7,088,568 loops=1)

  • Output: t_json_sal_spe.t_json_sal_spe_cdn, t_json_sal_spe.json_xli_css_spe, t_json_sal_spe.xmlf_flux_cdn, t_json_sal_spe.t_json_sal_xli_cdn
6. 14,177.136 14,177.136 ↓ 0.0 0 7,088,568

Index Only Scan using i_t_xml_file_ers3_sal_xmlf_cdn on ers3.t_xml_file_ers3_sal (cost=0.43..5.77 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=7,088,568)

  • Output: t_xml_file_ers3_sal.xmlf_cdn
  • Index Cond: (t_xml_file_ers3_sal.xmlf_cdn = t_json_sal_xli.xmlf_flux_cdn)
  • Heap Fetches: 0
Planning time : 234.307 ms
Execution time : 69,030.270 ms