explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b8ho

Settings
# exclusive inclusive rows x rows loops node
1. 23.850 10,697.276 ↑ 1.8 33,212 1

Group (cost=720,861.42..721,309.26 rows=59,712 width=14) (actual time=10,652.216..10,697.276 rows=33,212 loops=1)

2. 221.839 10,673.426 ↓ 1.1 68,123 1

Sort (cost=720,861.42..721,010.70 rows=59,712 width=14) (actual time=10,652.211..10,673.426 rows=68,123 loops=1)

  • Sort Key: o.oid, g.type_geom
  • Sort Method: external merge Disk: 2752kB
3. 2,360.642 10,451.587 ↓ 1.1 68,123 1

Hash Join (cost=303,897.24..715,102.55 rows=59,712 width=14) (actual time=5,593.168..10,451.587 rows=68,123 loops=1)

  • Hash Cond: (g.oid = o.oid)
4. 2,498.073 2,498.073 ↑ 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.027..2,498.073 rows=4,186,268 loops=1)

5. 27.870 5,592.872 ↓ 1.1 68,123 1

Hash (cost=302,917.10..302,917.10 rows=59,691 width=4) (actual time=5,592.872..5,592.872 rows=68,123 loops=1)

  • Buckets: 4096 Batches: 4 Memory Usage: 605kB
6. 1,992.005 5,565.002 ↓ 1.1 68,123 1

Hash Join (cost=100,719.40..302,917.10 rows=59,691 width=4) (actual time=2,077.674..5,565.002 rows=68,123 loops=1)

  • Hash Cond: (o.id_releve = r.rid)
7. 1,496.239 1,496.239 ↑ 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.057..1,496.239 rows=4,184,785 loops=1)

8. 24.741 2,076.758 ↓ 1.1 62,245 1

Hash (cost=99,756.06..99,756.06 rows=58,667 width=4) (actual time=2,076.758..2,076.758 rows=62,245 loops=1)

  • Buckets: 4096 Batches: 4 Memory Usage: 557kB
9. 774.669 2,052.017 ↓ 1.1 62,245 1

Hash Join (cost=831.13..99,756.06 rows=58,667 width=4) (actual time=12.990..2,052.017 rows=62,245 loops=1)

  • Hash Cond: (r.id_jdd = j.id_jdd)
10. 1,264.493 1,264.493 ↑ 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.017..1,264.493 rows=4,112,984 loops=1)

11. 0.011 12.855 ↓ 1.4 25 1

Hash (cost=830.91..830.91 rows=18 width=4) (actual time=12.855..12.855 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
12. 5.722 12.844 ↓ 1.4 25 1

Hash Join (cost=364.56..830.91 rows=18 width=4) (actual time=5.922..12.844 rows=25 loops=1)

  • Hash Cond: (j.id_ca = cadre.id_ca)
  • Join Filter: (((acteur_cadre.role_acteur = 2) AND (acteur_cadre.organisme = 33)) OR ((acteur_cadre.role_acteur = 3) AND (acteur_cadre.organisme = 33)) OR ((acteur_cadre.role_acteur = 4) AND (acteur_cadre.organisme = 33)) OR ((acteur_jdd.role_acteur = 6) AND (acteur_jdd.organisme = 33)))
  • Rows Removed by Join Filter: 12758
13. 1.880 5.090 ↓ 1.0 3,415 1

Hash Right Join (cost=255.55..402.55 rows=3,284 width=14) (actual time=1.528..5.090 rows=3,415 loops=1)

  • Hash Cond: (acteur_jdd.id_jdd = j.id_jdd)
14. 1.703 1.703 ↓ 1.0 3,415 1

Seq Scan on jdd_contact_donnees acteur_jdd (cost=0.00..101.84 rows=3,284 width=10) (actual time=0.005..1.703 rows=3,415 loops=1)

15. 0.418 1.507 ↓ 1.0 1,278 1

Hash (cost=239.69..239.69 rows=1,269 width=8) (actual time=1.507..1.507 rows=1,278 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 50kB
16. 1.089 1.089 ↓ 1.0 1,278 1

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

17. 0.404 2.032 ↓ 1.1 1,386 1

Hash (cost=93.08..93.08 rows=1,274 width=10) (actual time=2.032..2.032 rows=1,386 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 57kB
18. 0.640 1.628 ↓ 1.1 1,386 1

Hash Right Join (cost=35.82..93.08 rows=1,274 width=10) (actual time=0.316..1.628 rows=1,386 loops=1)

  • Hash Cond: (acteur_cadre.id_ca = cadre.id_ca)
19. 0.687 0.687 ↓ 1.0 1,306 1

Seq Scan on ca_contact acteur_cadre (cost=0.00..39.74 rows=1,274 width=10) (actual time=0.005..0.687 rows=1,306 loops=1)

20. 0.128 0.301 ↓ 1.0 423 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
21. 0.173 0.173 ↓ 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.023..0.173 rows=423 loops=1)

  • Heap Fetches: 43
Total runtime : 10,702.428 ms