explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ivuj

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 1.303 ↑ 1.0 25 1

Limit (cost=129.77..962.70 rows=25 width=148) (actual time=0.189..1.303 rows=25 loops=1)

2.          

CTE vm_temp

3. 0.000 0.014 ↓ 0.0 0 1

Unique (cost=65.82..70.52 rows=470 width=20) (actual time=0.014..0.014 rows=0 loops=1)

4. 0.014 0.014 ↓ 0.0 0 1

Sort (cost=65.82..68.17 rows=940 width=20) (actual time=0.014..0.014 rows=0 loops=1)

  • Sort Key: validation_manuelle_temp.oid, validation_manuelle_temp.date_heure, validation_manuelle_temp.vid
  • Sort Method: quicksort Memory: 25kB
5. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on validation_manuelle_temp (cost=0.00..19.40 rows=940 width=20) (actual time=0.000..0.000 rows=0 loops=1)

6. 0.105 1.289 ↑ 1,375.9 25 1

Nested Loop (cost=59.25..1,146,099.28 rows=34,398 width=148) (actual time=0.187..1.289 rows=25 loops=1)

7. 0.053 0.959 ↑ 1,375.9 25 1

Nested Loop (cost=58.82..859,870.63 rows=34,398 width=108) (actual time=0.154..0.959 rows=25 loops=1)

  • Join Filter: (temp.oid = g.oid)
8. 0.068 0.706 ↑ 1,375.9 25 1

Nested Loop (cost=58.39..574,412.24 rows=34,398 width=101) (actual time=0.138..0.706 rows=25 loops=1)

  • Join Filter: (temp.oid = o.oid)
9. 0.056 0.438 ↑ 1,375.9 25 1

Nested Loop (cost=57.96..288,953.77 rows=34,398 width=24) (actual time=0.118..0.438 rows=25 loops=1)

10. 0.028 0.132 ↑ 1,375.9 25 1

Hash Left Join (cost=57.52..3,448.69 rows=34,398 width=12) (actual time=0.097..0.132 rows=25 loops=1)

  • Hash Cond: (temp.oid = vm_temp.oid)
11. 0.072 0.087 ↑ 1,375.9 25 1

Seq Scan on temp_5705 temp (cost=42.25..1,324.19 rows=34,398 width=4) (actual time=0.065..0.087 rows=25 loops=1)

  • Filter: (NOT (hashed SubPlan 2))
12.          

SubPlan (for Seq Scan)

13. 0.010 0.015 ↑ 1,290.0 1 1

HashAggregate (cost=26.12..39.02 rows=1,290 width=4) (actual time=0.015..0.015 rows=1 loops=1)

14. 0.005 0.005 ↑ 1,290.0 1 1

Seq Scan on temp_observations_en_cours (cost=0.00..22.90 rows=1,290 width=4) (actual time=0.005..0.005 rows=1 loops=1)

15. 0.001 0.017 ↓ 0.0 0 1

Hash (cost=9.40..9.40 rows=470 width=8) (actual time=0.017..0.017 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
16. 0.016 0.016 ↓ 0.0 0 1

CTE Scan on vm_temp (cost=0.00..9.40 rows=470 width=8) (actual time=0.016..0.016 rows=0 loops=1)

17. 0.250 0.250 ↑ 1.0 1 25

Index Scan using observations_oid_idx on observations req_o (cost=0.43..8.29 rows=1 width=12) (actual time=0.010..0.010 rows=1 loops=25)

  • Index Cond: (oid = temp.oid)
18. 0.200 0.200 ↑ 1.0 1 25

Index Scan using observations_oid_idx on observations o (cost=0.43..8.29 rows=1 width=77) (actual time=0.008..0.008 rows=1 loops=25)

  • Index Cond: (oid = req_o.oid)
19. 0.200 0.200 ↑ 1.0 1 25

Index Scan using observations_geom_interne_oid_idx on observations_geom_interne g (cost=0.43..8.29 rows=1 width=19) (actual time=0.007..0.008 rows=1 loops=25)

  • Index Cond: (oid = o.oid)
20. 0.225 0.225 ↑ 1.0 1 25

Index Scan using releves_rid_idx on releves r (cost=0.43..8.29 rows=1 width=44) (actual time=0.008..0.009 rows=1 loops=25)

  • Index Cond: (rid = o.rid)
Total runtime : 1.554 ms