explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3sVN

Settings
# exclusive inclusive rows x rows loops node
1. 0.093 568.937 ↑ 86.0 3 1

Aggregate (cost=219,877.05..219,902.21 rows=258 width=2,344) (actual time=568.844..568.937 rows=3 loops=1)

  • Buffers: shared hit=34239
2.          

CTE entete

3. 12.699 399.728 ↑ 1.1 5,577 1

Hash Join (cost=4,556.27..15,646.69 rows=6,082 width=811) (actual time=325.217..399.728 rows=5,577 loops=1)

  • Buffers: shared hit=7092
4. 9.564 386.913 ↑ 1.1 5,577 1

Nested Loop (cost=4,552.91..15,559.7 rows=6,082 width=525) (actual time=325.046..386.913 rows=5,577 loops=1)

  • Buffers: shared hit=7089
5. 0.005 0.147 ↑ 1.0 1 1

Nested Loop (cost=0.83..17.9 rows=1 width=170) (actual time=0.135..0.147 rows=1 loops=1)

  • Buffers: shared hit=9
6. 0.012 0.095 ↑ 1.0 1 1

Nested Loop (cost=0.41..9.46 rows=1 width=92) (actual time=0.087..0.095 rows=1 loops=1)

  • Buffers: shared hit=5
7. 0.034 0.034 ↑ 1.0 1 1

Seq Scan on societes s (cost=0..1.01 rows=1 width=144) (actual time=0.031..0.034 rows=1 loops=1)

  • Filter: (s.soci_id = 'EHuB0wlY0s4amr5rK'::bpchar)
  • Buffers: shared hit=1
8. 0.049 0.049 ↑ 1.0 1 1

Index Scan using xx_clients_01 on clients cli (cost=0.41..8.43 rows=1 width=38) (actual time=0.046..0.049 rows=1 loops=1)

  • Index Cond: (cli.repe_id = '2EhJgF2IM4tUHThC9'::bpchar)
  • Buffers: shared hit=4
9. 0.047 0.047 ↑ 1.0 1 1

Index Scan using pk_repertoire on repertoire rep (cost=0.41..8.43 rows=1 width=78) (actual time=0.045..0.047 rows=1 loops=1)

  • Index Cond: (rep.repe_id = '2EhJgF2IM4tUHThC9'::bpchar)
  • Buffers: shared hit=4
10. 21.698 377.202 ↑ 1.1 5,577 1

Hash Join (cost=4,552.09..15,480.98 rows=6,082 width=445) (actual time=324.906..377.202 rows=5,577 loops=1)

  • Buffers: shared hit=7080
11. 33.693 33.693 ↑ 1.1 5,577 1

Index Scan using xx_cdcentete_03 on cdcentete e_1 (cost=0.55..10,845.82 rows=6,082 width=177) (actual time=0.072..33.693 rows=5,577 loops=1)

  • Index Cond: ((e_1.cdce_idsoc = 'EHuB0wlY0s4amr5rK'::bpchar) AND (e_1.cdce_idpay = '2EhJgF2IM4tUHThC9'::bpchar))
  • Buffers: shared hit=4107
12. 184.704 321.811 ↑ 1.0 70,157 1

Hash (cost=3,674.57..3,674.57 rows=70,157 width=286) (actual time=321.81..321.811 rows=70,157 loops=1)

  • Buffers: shared hit=2973
13. 137.107 137.107 ↑ 1.0 70,157 1

Seq Scan on adresses adr (cost=0..3,674.57 rows=70,157 width=286) (actual time=0.042..137.107 rows=70,157 loops=1)

  • Buffers: shared hit=2973
14. 0.051 0.116 ↑ 1.0 16 1

Hash (cost=3.16..3.16 rows=16 width=304) (actual time=0.115..0.116 rows=16 loops=1)

  • Buffers: shared hit=3
15. 0.065 0.065 ↑ 1.0 16 1

Seq Scan on agences a (cost=0..3.16 rows=16 width=304) (actual time=0.029..0.065 rows=16 loops=1)

  • Buffers: shared hit=3
16. 0.825 568.844 ↑ 13.6 19 1

Sort (cost=204,230.37..204,231.01 rows=258 width=2,344) (actual time=568.828..568.844 rows=19 loops=1)

  • Sort Key: e.repe_codei, e.repe_libel, e.repe_id, e.agen_codei, e.agen_libel, e.agen_id, e.adre_nom, e.adre_adr1, e.adre_adr2, e.adre_adr3, e.adre_adr4, e.adre_copos, e.adre_budis, e.adre_tel, e.cdce_dtbon, e.cdce_codei, e.adre_id, e.adre_codei, e.cdce_idsoc, e.cdce_facav, e.cdce_id, e.monn_code, e.clie_type, e.adre_civil, e.cdce_dtexp, e.cdce_march, e.cdce_idpay, e.cdce_idcli, e.cdce_idfac, p.cdcp_dtexp
  • Sort Method: quicksort Memory: 44kB
  • Buffers: shared hit=34239
17. 0.082 568.019 ↑ 13.6 19 1

Nested Loop (cost=1.11..204,220.03 rows=258 width=2,344) (actual time=561.339..568.019 rows=19 loops=1)

  • Buffers: shared hit=34233
18. 16.618 567.443 ↑ 9.1 19 1

Nested Loop (cost=0.56..202,778.53 rows=173 width=2,366) (actual time=561.283..567.443 rows=19 loops=1)

  • Buffers: shared hit=34138
19. 428.131 428.131 ↑ 1.1 5,577 1

CTE Scan on entete e (cost=0..121.64 rows=6,082 width=2,308) (actual time=325.234..428.131 rows=5,577 loops=1)

  • Buffers: shared hit=7092
20. 122.694 122.694 ↓ 0.0 0 5,577

Index Scan using cdcdetailp_trans on cdcdetailp p (cost=0.56..33.31 rows=1 width=58) (actual time=0.022..0.022 rows=0 loops=5,577)

  • Index Cond: ((p.cdce_id = e.cdce_id) AND (p.cdcp_tyvte = 'LIV'::bpchar))
  • Filter: ((p.cdcp_etat IS NULL) AND (p.cdcp_etat IS NULL) AND (p.cdcp_tycdc = 'STO'::bpchar) AND ((p.cdcp_etali = 'A'::bpchar) OR (p.cdcp_etali = 'C'::bpchar) OR (p.cdcp_etali = 'P'::bpchar)) AND ((p.cdcp_etali = 'A'::bpchar) OR (p.cdcp_etali = 'C'::bpchar) OR (p.cdcp_etali = 'P'::bpchar)))
  • Buffers: shared hit=27046
21. 0.494 0.494 ↑ 1.0 1 19

Index Scan using xx_cdcdetailc_07 on cdcdetailc c (cost=0.56..8.32 rows=1 width=22) (actual time=0.025..0.026 rows=1 loops=19)

  • Index Cond: ((c.cdcc_id = p.cdcc_id) AND (c.cdce_id = p.cdce_id))
  • Filter: (((c.cdcc_kitsa = 0) OR (c.cdcc_kitsa IS NULL)) AND ((c.cdcc_cdatt = 0) OR (c.cdcc_cdatt IS NULL)))
  • Buffers: shared hit=95