explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JEls

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 151.221 ↑ 1.0 25 1

Limit (cost=84,848.97..84,849.04 rows=25 width=148) (actual time=151.209..151.221 rows=25 loops=1)

2.          

CTE vm_temp

3. 0.003 0.032 ↑ 94.0 5 1

Unique (cost=65.82..70.52 rows=470 width=20) (actual time=0.028..0.032 rows=5 loops=1)

4. 0.022 0.029 ↑ 134.3 7 1

Sort (cost=65.82..68.17 rows=940 width=20) (actual time=0.027..0.029 rows=7 loops=1)

  • Sort Key: validation_manuelle_temp.oid, validation_manuelle_temp.date_heure, validation_manuelle_temp.vid
  • Sort Method: quicksort Memory: 25kB
5. 0.007 0.007 ↑ 134.3 7 1

Seq Scan on validation_manuelle_temp (cost=0.00..19.40 rows=940 width=20) (actual time=0.005..0.007 rows=7 loops=1)

6. 7.216 151.213 ↑ 101.5 25 1

Sort (cost=84,778.45..84,784.80 rows=2,537 width=148) (actual time=151.207..151.213 rows=25 loops=1)

  • Sort Key: o.tax_nom_lat
  • Sort Method: top-N heapsort Memory: 31kB
7. 12.109 143.997 ↓ 2.0 5,074 1

Hash Left Join (cost=59.25..84,706.86 rows=2,537 width=148) (actual time=0.178..143.997 rows=5,074 loops=1)

  • Hash Cond: (temp.oid = vm_temp.oid)
8. 4.681 131.848 ↓ 2.0 5,074 1

Nested Loop (cost=43.98..84,470.42 rows=2,537 width=140) (actual time=0.110..131.848 rows=5,074 loops=1)

9. 6.502 101.797 ↓ 2.0 5,074 1

Nested Loop (cost=43.55..63,423.39 rows=2,537 width=100) (actual time=0.095..101.797 rows=5,074 loops=1)

  • Join Filter: (temp.oid = o.oid)
10. 4.169 69.925 ↓ 2.0 5,074 1

Nested Loop (cost=43.11..42,369.71 rows=2,537 width=35) (actual time=0.080..69.925 rows=5,074 loops=1)

  • Join Filter: (temp.oid = g.oid)
11. 5.909 40.386 ↓ 2.0 5,074 1

Nested Loop (cost=42.68..21,316.04 rows=2,537 width=16) (actual time=0.064..40.386 rows=5,074 loops=1)

12. 4.022 4.033 ↓ 2.0 5,074 1

Seq Scan on temp_5694 temp (cost=42.25..134.68 rows=2,537 width=4) (actual time=0.046..4.033 rows=5,074 loops=1)

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

SubPlan (for Seq Scan)

14. 0.006 0.011 ↑ 1,290.0 1 1

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

15. 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.004..0.005 rows=1 loops=1)

16. 30.444 30.444 ↑ 1.0 1 5,074

Index Scan using observations_oid_idx on observations req_o (cost=0.43..8.34 rows=1 width=12) (actual time=0.005..0.006 rows=1 loops=5,074)

  • Index Cond: (oid = temp.oid)
17. 25.370 25.370 ↑ 1.0 1 5,074

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.004..0.005 rows=1 loops=5,074)

  • Index Cond: (oid = req_o.oid)
18. 25.370 25.370 ↑ 1.0 1 5,074

Index Scan using observations_oid_idx on observations o (cost=0.43..8.29 rows=1 width=77) (actual time=0.005..0.005 rows=1 loops=5,074)

  • Index Cond: (oid = req_o.oid)
19. 25.370 25.370 ↑ 1.0 1 5,074

Index Scan using releves_rid_idx on releves r (cost=0.43..8.29 rows=1 width=44) (actual time=0.004..0.005 rows=1 loops=5,074)

  • Index Cond: (rid = o.rid)
20. 0.004 0.040 ↑ 94.0 5 1

Hash (cost=9.40..9.40 rows=470 width=8) (actual time=0.040..0.040 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
21. 0.036 0.036 ↑ 94.0 5 1

CTE Scan on vm_temp (cost=0.00..9.40 rows=470 width=8) (actual time=0.030..0.036 rows=5 loops=1)

Total runtime : 151.477 ms