explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z4RI

Settings
# exclusive inclusive rows x rows loops node
1. 1.211 120.236 ↑ 34.5 83 1

GroupAggregate (cost=46,363.73..46,435.36 rows=2,865 width=154) (actual time=118.525..120.236 rows=83 loops=1)

2. 54.024 119.025 ↑ 1.0 2,865 1

Sort (cost=46,363.73..46,370.90 rows=2,865 width=154) (actual time=118.484..119.025 rows=2,865 loops=1)

  • Sort Key: c.nom_complet, j.nom_complet, c.uuid, j.uuid
  • Sort Method: quicksort Memory: 764kB
3. 1.791 65.001 ↑ 1.0 2,865 1

Hash Join (cost=352.19..46,199.22 rows=2,865 width=154) (actual time=3.870..65.001 rows=2,865 loops=1)

  • Hash Cond: (j.id_ca = c.id_ca)
4. 2.330 62.171 ↑ 1.0 2,865 1

Hash Join (cost=266.23..46,073.87 rows=2,865 width=75) (actual time=2.813..62.171 rows=2,865 loops=1)

  • Hash Cond: (r.id_jdd = j.id_jdd)
5. 2.953 57.179 ↑ 1.0 2,865 1

Nested Loop (cost=0.86..45,765.53 rows=2,865 width=8) (actual time=0.123..57.179 rows=2,865 loops=1)

6. 4.499 34.171 ↑ 1.0 2,865 1

Nested Loop (cost=0.43..23,413.71 rows=2,865 width=8) (actual time=0.077..34.171 rows=2,865 loops=1)

7. 1.022 1.022 ↑ 1.0 2,865 1

Seq Scan on temp_5692 cache (cost=0.00..44.65 rows=2,865 width=4) (actual time=0.017..1.022 rows=2,865 loops=1)

8. 28.650 28.650 ↑ 1.0 1 2,865

Index Scan using observations_oid_idx on observations o (cost=0.43..8.15 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=2,865)

  • Index Cond: (oid = cache.oid)
9. 20.055 20.055 ↑ 1.0 1 2,865

Index Scan using releves_rid_idx on releves r (cost=0.43..7.79 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=2,865)

  • Index Cond: (rid = o.id_releve)
10. 0.712 2.662 ↓ 1.0 1,729 1

Hash (cost=244.05..244.05 rows=1,705 width=75) (actual time=2.662..2.662 rows=1,729 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 184kB
11. 1.950 1.950 ↓ 1.0 1,729 1

Seq Scan on jdd j (cost=0.00..244.05 rows=1,705 width=75) (actual time=0.018..1.950 rows=1,729 loops=1)

12. 0.279 1.039 ↓ 1.0 578 1

Hash (cost=78.76..78.76 rows=576 width=87) (actual time=1.039..1.039 rows=578 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 69kB
13. 0.760 0.760 ↓ 1.0 578 1

Seq Scan on ca c (cost=0.00..78.76 rows=576 width=87) (actual time=0.022..0.760 rows=578 loops=1)

Total runtime : 120.596 ms