explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dysh

Settings
# exclusive inclusive rows x rows loops node
1. 16.556 5,789.008 ↑ 109.8 260 1

GroupAggregate (cost=478,062.03..479,061.56 rows=28,558 width=104) (actual time=5,303.254..5,789.008 rows=260 loops=1)

2. 1,659.151 5,772.452 ↓ 1.0 29,565 1

Sort (cost=478,062.03..478,133.43 rows=28,558 width=104) (actual time=5,303.093..5,772.452 rows=29,565 loops=1)

  • Sort Key: tax.cd_nom, tax.lb_nom, tax.lb_auteur, tax.premier_nom_vern, ref.meilleure_photo_disponible, ref.extension_imagine_filter, ref.icone
  • Sort Method: external merge Disk: 3,776kB
3. 21.882 4,113.301 ↓ 1.0 29,565 1

Hash Left Join (cost=208,923.25..474,384.01 rows=28,558 width=104) (actual time=3,433.718..4,113.301 rows=29,565 loops=1)

  • Hash Cond: (o.cd_espece = ref.cd_ref)
4. 61.314 4,085.276 ↓ 1.0 29,565 1

Hash Join (cost=208,430.49..473,188.39 rows=28,558 width=74) (actual time=3,427.550..4,085.276 rows=29,565 loops=1)

  • Hash Cond: (o.cd_espece = tax.cd_nom)
5. 473.103 3,592.640 ↑ 1.0 29,624 1

Hash Join (cost=192,629.75..454,169.37 rows=29,712 width=16) (actual time=2,996.148..3,592.640 rows=29,624 loops=1)

  • Hash Cond: (o.id_releve = r.rid)
6. 28.500 123.867 ↑ 1.0 29,624 1

Nested Loop (cost=0.43..236,875.95 rows=29,712 width=12) (actual time=0.095..123.867 rows=29,624 loops=1)

7. 6.081 6.081 ↑ 1.0 29,762 1

Seq Scan on temp_9912 cache (cost=0.00..492.62 rows=29,762 width=4) (actual time=0.012..6.081 rows=29,762 loops=1)

8. 89.286 89.286 ↑ 1.0 1 29,762

Index Scan using observations_oid_idx on observations o (cost=0.43..7.93 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=29,762)

  • Index Cond: (oid = cache.oid)
  • Filter: (o_presence = 1)
  • Rows Removed by Filter: 0
9. 1,486.607 2,995.670 ↑ 1.0 4,876,831 1

Hash (cost=107,848.03..107,848.03 rows=4,877,303 width=12) (actual time=2,995.670..2,995.670 rows=4,876,831 loops=1)

  • Buckets: 4,096 Batches: 256 Memory Usage: 793kB
10. 1,509.063 1,509.063 ↑ 1.0 4,876,831 1

Seq Scan on releves r (cost=0.00..107,848.03 rows=4,877,303 width=12) (actual time=0.013..1,509.063 rows=4,876,831 loops=1)

11. 225.919 431.322 ↑ 1.0 228,522 1

Hash (cost=10,489.22..10,489.22 rows=228,522 width=58) (actual time=431.322..431.322 rows=228,522 loops=1)

  • Buckets: 2,048 Batches: 32 Memory Usage: 508kB
12. 205.403 205.403 ↑ 1.0 228,522 1

Seq Scan on vm_taxref_last tax (cost=0.00..10,489.22 rows=228,522 width=58) (actual time=0.015..205.403 rows=228,522 loops=1)

13. 2.797 6.143 ↑ 1.0 10,167 1

Hash (cost=365.67..365.67 rows=10,167 width=38) (actual time=6.143..6.143 rows=10,167 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 514kB
14. 3.346 3.346 ↑ 1.0 10,167 1

Seq Scan on referentiel_espece_continental ref (cost=0.00..365.67 rows=10,167 width=38) (actual time=0.005..3.346 rows=10,167 loops=1)

Total runtime : 5,790.807 ms