explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d8Ck

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

Aggregate (cost=1,632,728.81..1,632,728.82 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.56..1,632,727.27 rows=617 width=0) (actual rows= loops=)

  • Join Filter: (pamo.pamo_id = c.cmd_pamo_id)
  • Filter: ((((cmty.cmty_i18n_label)::text = 'i18n_cmdTypeNormal'::text) AND (((pamy.pamy_i18n_label)::text = ANY ('{i18n_paiementMoyenCB,i18n_paiementNXCB,i18n_paiementMoyenAurore,i18n_paiementMoyenCetelem,i18n_paiementMoyenCetelemPresto,i18n_paiementMoyenAutre,i18n_paiementMoyenVirement,i18n_paiementPAYPAL,i18n_paiementCKDO}'::text[])) OR (((pamy.pamy_i18n_label)::text = 'i18n_paiementMoyenCheque'::text) AND ((c.cmd_date_update + '5 days'::interval) < ('now'::cstring)::timestamp(6) without time zone)))) OR ((pamo.pamo_i18n_label)::text = 'i18n_paiementModeAucun'::text) OR ((cmty.cmty_i18n_label)::text = ANY ('{i18n_cmdTypeEchange,i18n_cmdTypePieceRechange,i18n_cmdTypeModification,i18n_cmdTypeLivraisonPartielle}'::text[])))
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.56..1,632,594.17 rows=903 width=55) (actual rows= loops=)

  • Join Filter: (pamy.pamy_id = c.cmd_pamy_id)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..1,632,281.35 rows=903 width=34) (actual rows= loops=)

  • Join Filter: (c.cmd_cmty_id = cmty.cmty_id)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..1,632,171.89 rows=903 width=14) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on "commandesRegroup" cr (cost=0.00..1,152,591.43 rows=122,424 width=4) (actual rows= loops=)

  • Filter: (reg_rsta_id = 1)
7. 0.000 0.000 ↓ 0.0

Index Scan using pk_cmd_id on commandes c (cost=0.56..3.91 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (cmd_id = cr.reg_cmd_id)
  • Filter: (cmd_ispayed AND cmd_isprereserv AND (NOT cmd_isinfossent) AND (NOT cmd_iscanceled) AND (cmd_cli_id <> '-1'::integer) AND (cmd_stage = 5) AND (cmd_date_update < (now() - '01:00:00'::interval)))
8. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.12 rows=8 width=24) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on "commandesType" cmty (cost=0.00..1.08 rows=8 width=24) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.34 rows=23 width=25) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on "paiementMoyen" pamy (cost=0.00..1.23 rows=23 width=25) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.04 rows=3 width=26) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on "paiementMode" pamo (cost=0.00..1.03 rows=3 width=26) (actual rows= loops=)