explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p7oE

Settings
# exclusive inclusive rows x rows loops node
1. 793.510 17,886.638 ↑ 126.0 33,212 1

Hash Join (cost=494,387.46..1,036,231.02 rows=4,186,163 width=14) (actual time=9,957.089..17,886.638 rows=33,212 loops=1)

  • Hash Cond: (r.id_jdd = j.id_jdd)
2. 4,536.516 17,090.074 ↓ 1.0 4,195,172 1

Hash Join (cost=494,032.54..978,314.91 rows=4,186,268 width=18) (actual time=9,936.567..17,090.074 rows=4,195,172 loops=1)

  • Hash Cond: (g.oid = o.oid)
3. 2,622.538 2,622.538 ↑ 1.0 4,186,268 1

Seq Scan on observations_geom_interne g (cost=0.00..353,793.68 rows=4,186,268 width=14) (actual time=0.005..2,622.538 rows=4,186,268 loops=1)

4. 1,488.365 9,931.020 ↓ 1.0 4,186,269 1

Hash (cost=425,375.73..425,375.73 rows=4,184,785 width=8) (actual time=9,931.020..9,931.020 rows=4,186,269 loops=1)

  • Buckets: 4096 Batches: 256 Memory Usage: 654kB
5. 4,280.909 8,442.655 ↓ 1.0 4,186,269 1

Hash Join (cost=150,397.14..425,375.73 rows=4,184,785 width=8) (actual time=2,650.192..8,442.655 rows=4,186,269 loops=1)

  • Hash Cond: (o.id_releve = r.rid)
6. 1,517.523 1,517.523 ↑ 1.0 4,184,785 1

Seq Scan on observations o (cost=0.00..152,983.85 rows=4,184,785 width=8) (actual time=0.058..1,517.523 rows=4,184,785 loops=1)

7. 1,298.736 2,644.223 ↑ 1.0 4,112,984 1

Hash (cost=82,917.84..82,917.84 rows=4,112,984 width=8) (actual time=2,644.223..2,644.223 rows=4,112,984 loops=1)

  • Buckets: 4096 Batches: 256 Memory Usage: 642kB
8. 1,345.487 1,345.487 ↑ 1.0 4,112,984 1

Seq Scan on releves r (cost=0.00..82,917.84 rows=4,112,984 width=8) (actual time=0.013..1,345.487 rows=4,112,984 loops=1)

9. 0.007 3.054 ↑ 181.3 7 1

Hash (cost=339.06..339.06 rows=1,269 width=4) (actual time=3.054..3.054 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
10. 0.307 3.047 ↑ 181.3 7 1

Hash Left Join (cost=72.36..339.06 rows=1,269 width=4) (actual time=1.084..3.047 rows=7 loops=1)

  • Hash Cond: (j.id_ca = acteur_cadre.id_ca)
  • Filter: ((acteur_jdd.id_jdd IS NOT NULL) OR (acteur_cadre.id_ca IS NOT NULL))
  • Rows Removed by Filter: 1271
11. 0.538 2.691 ↓ 1.0 1,278 1

Hash Left Join (cost=58.97..320.88 rows=1,269 width=12) (actual time=0.474..2.691 rows=1,278 loops=1)

  • Hash Cond: (j.id_jdd = acteur_jdd.id_jdd)
12. 0.625 2.062 ↓ 1.0 1,278 1

Hash Join (cost=35.82..292.96 rows=1,269 width=8) (actual time=0.376..2.062 rows=1,278 loops=1)

  • Hash Cond: (j.id_ca = cadre.id_ca)
13. 1.086 1.086 ↓ 1.0 1,278 1

Seq Scan on jdd j (cost=0.00..239.69 rows=1,269 width=8) (actual time=0.011..1.086 rows=1,278 loops=1)

14. 0.164 0.351 ↓ 1.0 423 1

Hash (cost=30.57..30.57 rows=420 width=4) (actual time=0.351..0.351 rows=423 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
15. 0.187 0.187 ↓ 1.0 423 1

Index Only Scan using pkey_cadre_acquisition on ca cadre (cost=0.27..30.57 rows=420 width=4) (actual time=0.011..0.187 rows=423 loops=1)

  • Heap Fetches: 43
16. 0.004 0.091 ↓ 7.0 7 1

Hash (cost=23.13..23.13 rows=1 width=4) (actual time=0.091..0.091 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
17. 0.011 0.087 ↓ 7.0 7 1

HashAggregate (cost=23.11..23.12 rows=1 width=4) (actual time=0.085..0.087 rows=7 loops=1)

18. 0.054 0.076 ↓ 3.5 7 1

Bitmap Heap Scan on jdd_contact_donnees acteur_jdd (cost=4.33..23.11 rows=2 width=4) (actual time=0.045..0.076 rows=7 loops=1)

  • Recheck Cond: (organisme = 33)
  • Filter: (role_acteur = 6)
  • Rows Removed by Filter: 14
19. 0.022 0.022 ↓ 4.5 27 1

Bitmap Index Scan on jdd_contact_donnees_organisme_idx (cost=0.00..4.33 rows=6 width=0) (actual time=0.022..0.022 rows=27 loops=1)

  • Index Cond: (organisme = 33)
20. 0.001 0.049 ↓ 2.0 2 1

Hash (cost=13.38..13.38 rows=1 width=4) (actual time=0.049..0.049 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
21. 0.005 0.048 ↓ 2.0 2 1

HashAggregate (cost=13.36..13.37 rows=1 width=4) (actual time=0.047..0.048 rows=2 loops=1)

22. 0.028 0.043 ↓ 3.0 3 1

Bitmap Heap Scan on ca_contact acteur_cadre (cost=4.30..13.36 rows=1 width=4) (actual time=0.032..0.043 rows=3 loops=1)

  • Recheck Cond: (organisme = 33)
  • Filter: ((role_acteur = 2) OR (role_acteur = 3) OR (role_acteur = 4))
  • Rows Removed by Filter: 5
23. 0.015 0.015 ↓ 4.0 12 1

Bitmap Index Scan on ca_contact_organisme_idx (cost=0.00..4.30 rows=3 width=0) (actual time=0.015..0.015 rows=12 loops=1)

  • Index Cond: (organisme = 33)
Total runtime : 17,891.889 ms