explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tUeR

Settings
# exclusive inclusive rows x rows loops node
1. 14.983 9,771.444 ↑ 98,962.0 1 1

GroupAggregate (cost=613,432.97..616,896.64 rows=98,962 width=104) (actual time=9,771.444..9,771.444 rows=1 loops=1)

2. 872.348 9,756.461 ↑ 3.7 26,973 1

Sort (cost=613,432.97..613,680.38 rows=98,962 width=104) (actual time=9,749.212..9,756.461 rows=26,973 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 sort Disk: 2,904kB
3. 3,449.908 8,884.113 ↑ 3.7 26,973 1

Hash Join (cost=198,678.79..594,392.81 rows=98,962 width=104) (actual time=2,634.992..8,884.113 rows=26,973 loops=1)

  • Hash Cond: (r.rid = o.id_releve)
4. 2,986.115 2,986.115 ↑ 1.0 9,376,062 1

Seq Scan on releves r (cost=0.00..220,427.54 rows=9,379,754 width=12) (actual time=0.136..2,986.115 rows=9,376,062 loops=1)

5. 4.898 2,448.090 ↑ 4.4 8,991 1

Hash (cost=197,556.18..197,556.18 rows=39,889 width=100) (actual time=2,448.090..2,448.090 rows=8,991 loops=1)

  • Buckets: 1,024 Batches: 8 Memory Usage: 276kB
6. 5.027 2,443.192 ↑ 4.4 8,991 1

Hash Left Join (cost=16,291.90..197,556.18 rows=39,889 width=100) (actual time=2,433.396..2,443.192 rows=8,991 loops=1)

  • Hash Cond: (o.cd_espece = ref.cd_ref)
7. 14.439 2,430.438 ↑ 4.4 8,991 1

Hash Join (cost=15,800.93..196,087.73 rows=39,889 width=70) (actual time=2,425.645..2,430.438 rows=8,991 loops=1)

  • Hash Cond: (o.cd_espece = tax.cd_nom)
8. 5.555 15.299 ↑ 4.7 8,991 1

Nested Loop (cost=0.43..176,761.06 rows=41,966 width=12) (actual time=0.089..15.299 rows=8,991 loops=1)

9. 0.753 0.753 ↑ 1.0 2,997 1

Seq Scan on temp_9227 cache (cost=0.00..46.97 rows=2,997 width=4) (actual time=0.037..0.753 rows=2,997 loops=1)

10. 8.991 8.991 ↑ 4.7 3 2,997

Index Scan using observations_oid_idx on observations o (cost=0.43..58.82 rows=14 width=12) (actual time=0.002..0.003 rows=3 loops=2,997)

  • Index Cond: (oid = cache.oid)
  • Filter: (o_presence = 1)
11. 2,275.014 2,400.700 ↑ 1.0 228,511 1

Hash (cost=10,489.11..10,489.11 rows=228,511 width=58) (actual time=2,400.700..2,400.700 rows=228,511 loops=1)

  • Buckets: 2,048 Batches: 32 Memory Usage: 505kB
12. 125.686 125.686 ↑ 1.0 228,511 1

Seq Scan on vm_taxref_last tax (cost=0.00..10,489.11 rows=228,511 width=58) (actual time=0.011..125.686 rows=228,511 loops=1)

13. 3.286 7.727 ↑ 1.0 10,132 1

Hash (cost=364.32..364.32 rows=10,132 width=38) (actual time=7.727..7.727 rows=10,132 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 512kB
14. 4.441 4.441 ↑ 1.0 10,132 1

Seq Scan on referentiel_espece_continental ref (cost=0.00..364.32 rows=10,132 width=38) (actual time=0.012..4.441 rows=10,132 loops=1)

Total runtime : 9,772.803 ms