explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ptyH

Settings
# exclusive inclusive rows x rows loops node
1. 41,664.741 42,253.410 ↑ 1.0 409,653 1

Sort (cost=1,633,669.78..1,634,729.28 rows=423,801 width=2,154) (actual time=34,640.289..42,253.410 rows=409,653 loops=1)

  • Sort Key: i0_.nom_complet, i3_.nom_complet
  • Sort Method: external merge Disk: 724936kB
2. 521.879 588.669 ↑ 1.0 409,653 1

Hash Join (cost=2,941.98..12,241.16 rows=423,801 width=2,154) (actual time=49.506..588.669 rows=409,653 loops=1)

  • Hash Cond: (i8_.id_jdd = i3_.id_jdd)
3. 19.089 19.089 ↑ 1.0 70,643 1

Seq Scan on vm_cd_espece_nb_obs_date_max_par_jdd_occurence i8_ (cost=0.00..1,746.43 rows=70,643 width=4) (actual time=0.007..19.089 rows=70,643 loops=1)

4. 31.543 47.701 ↓ 1.3 9,394 1

Hash (cost=881.75..881.75 rows=7,379 width=2,158) (actual time=47.701..47.701 rows=9,394 loops=1)

  • Buckets: 1024 Batches: 64 (originally 16) Memory Usage: 1025kB
5. 5.236 16.158 ↓ 1.3 9,394 1

Hash Join (cost=388.46..881.75 rows=7,379 width=2,158) (actual time=4.771..16.158 rows=9,394 loops=1)

  • Hash Cond: (i3_.id_jdd = i7_.id_jdd)
6. 1.692 9.267 ↓ 1.0 2,856 1

Hash Join (cost=244.58..595.40 rows=2,747 width=2,154) (actual time=3.111..9.267 rows=2,856 loops=1)

  • Hash Cond: (i0_.id_ca = i6_.id_ca)
7. 0.721 6.943 ↓ 1.0 1,050 1

Hash Join (cost=189.97..482.53 rows=1,027 width=2,154) (actual time=2.471..6.943 rows=1,050 loops=1)

  • Hash Cond: (i3_.id_statut_metadonnee = i5_.id_ref)
8. 0.779 6.212 ↓ 1.0 1,050 1

Hash Join (cost=166.02..444.46 rows=1,027 width=2,054) (actual time=2.454..6.212 rows=1,050 loops=1)

  • Hash Cond: (i3_.id_numerisateur = i4_.uid)
9. 1.132 5.005 ↓ 1.0 1,050 1

Hash Join (cost=142.67..406.99 rows=1,027 width=1,710) (actual time=2.020..5.005 rows=1,050 loops=1)

  • Hash Cond: (i3_.id_ca = i0_.id_ca)
10. 1.878 1.878 ↓ 1.0 1,068 1

Seq Scan on jdd i3_ (cost=0.00..250.06 rows=1,064 width=537) (actual time=0.013..1.878 rows=1,068 loops=1)

  • Filter: ((NOT blocage_diffusion) AND (type_donnees = 1) AND (id_diffusion = ANY ('{9,10,11,12,13}'::integer[])))
  • Rows Removed by Filter: 169
11. 0.783 1.995 ↑ 1.1 392 1

Hash (cost=137.13..137.13 rows=443 width=1,173) (actual time=1.995..1.995 rows=392 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 333kB
12. 0.241 1.212 ↑ 1.1 392 1

Hash Join (cost=47.30..137.13 rows=443 width=1,173) (actual time=0.419..1.212 rows=392 loops=1)

  • Hash Cond: (i0_.id_numerisateur = i1_.uid)
13. 0.320 0.578 ↑ 1.1 392 1

Hash Join (cost=23.95..107.69 rows=443 width=829) (actual time=0.019..0.578 rows=392 loops=1)

  • Hash Cond: (i0_.id_statut_metadonnee = i2_.id_ref)
14. 0.251 0.251 ↑ 1.1 412 1

Seq Scan on ca i0_ (cost=0.00..77.59 rows=459 width=729) (actual time=0.004..0.251 rows=412 loops=1)

15. 0.005 0.007 ↑ 124.0 5 1

Hash (cost=16.20..16.20 rows=620 width=100) (actual time=0.007..0.007 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
16. 0.002 0.002 ↑ 124.0 5 1

Seq Scan on ref_statut_metadonnee i2_ (cost=0.00..16.20 rows=620 width=100) (actual time=0.002..0.002 rows=5 loops=1)

17. 0.224 0.393 ↓ 1.0 465 1

Hash (cost=17.60..17.60 rows=460 width=344) (actual time=0.393..0.393 rows=465 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 93kB
18. 0.169 0.169 ↓ 1.0 465 1

Seq Scan on utilisateur i1_ (cost=0.00..17.60 rows=460 width=344) (actual time=0.002..0.169 rows=465 loops=1)

19. 0.240 0.428 ↓ 1.0 465 1

Hash (cost=17.60..17.60 rows=460 width=344) (actual time=0.428..0.428 rows=465 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 93kB
20. 0.188 0.188 ↓ 1.0 465 1

Seq Scan on utilisateur i4_ (cost=0.00..17.60 rows=460 width=344) (actual time=0.004..0.188 rows=465 loops=1)

21. 0.004 0.010 ↑ 124.0 5 1

Hash (cost=16.20..16.20 rows=620 width=100) (actual time=0.010..0.010 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
22. 0.006 0.006 ↑ 124.0 5 1

Seq Scan on ref_statut_metadonnee i5_ (cost=0.00..16.20 rows=620 width=100) (actual time=0.005..0.006 rows=5 loops=1)

23. 0.309 0.632 ↓ 1.0 1,244 1

Hash (cost=39.27..39.27 rows=1,227 width=4) (actual time=0.632..0.632 rows=1,244 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 44kB
24. 0.323 0.323 ↓ 1.0 1,244 1

Seq Scan on ca_contact i6_ (cost=0.00..39.27 rows=1,227 width=4) (actual time=0.006..0.323 rows=1,244 loops=1)

25. 0.793 1.655 ↑ 1.0 3,272 1

Hash (cost=102.28..102.28 rows=3,328 width=4) (actual time=1.655..1.655 rows=3,272 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 116kB
26. 0.862 0.862 ↑ 1.0 3,272 1

Seq Scan on jdd_contact_donnees i7_ (cost=0.00..102.28 rows=3,328 width=4) (actual time=0.007..0.862 rows=3,272 loops=1)

Total runtime : 42,454.123 ms