explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s8he

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 27,316.937 ↑ 1.0 1 1

"Limit (cost=1,593,017.27..1,593,017.27 rows=1 width=1,068) (actual time=27,316.933..27,316.937 rows=1 loops=1)

2. 4,448.730 27,316.932 ↑ 11,948,962.0 1 1

Sort (cost=1,593,017.27..1,622,889.67 rows=11,948,962 width=1,068) (actual time=27,316.932..27,316.932 rows=1 loops=1)

  • Sort Key: v_evve.""EVVE_ID"
  • Sort Method: top-N heapsort Memory: 26kB
3. 3,263.619 22,868.202 ↓ 1.0 11,950,157 1

Hash Join (cost=162.27..1,533,272.46 rows=11,948,962 width=1,068) (actual time=2.604..22,868.202 rows=11,950,157 loops=1)

  • Hash Cond: (v_evve.""EVVE_K_VE_ID"" = ve.""VE_ID"")
4. 19,602.391 19,602.391 ↓ 1.0 11,950,157 1

Seq Scan on ""T_EVENT_VE"" v_evve (cost=0.00..1,368,811.96 rows=11,948,962 width=755) (actual time=0.398..19,602.391 rows=11,950,157 loops=1)

  • Filter: (""EVVE_ID"" > 1)
5. 0.549 2.192 ↓ 1.0 1,761 1

Hash (cost=140.30..140.30 rows=1,757 width=317) (actual time=2.192..2.192 rows=1,761 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 266kB
6. 0.296 1.643 ↓ 1.0 1,761 1

Hash Left Join (cost=44.22..140.30 rows=1,757 width=317) (actual time=0.443..1.643 rows=1,761 loops=1)

  • Hash Cond: (ve.""VE_K_PMVE_ID"" = pmve.""PMVE_ID"")
7. 0.476 1.308 ↓ 1.0 1,761 1

Hash Join (cost=42.90..115.63 rows=1,757 width=85) (actual time=0.398..1.308 rows=1,761 loops=1)

  • Hash Cond: (ve.""VE_K_GRPM_ID"" = grpm.""GRPM_ID"")
8. 0.455 0.455 ↓ 1.0 1,761 1

Seq Scan on ""T_VE"" ve (cost=0.00..48.57 rows=1,757 width=38) (actual time=0.015..0.455 rows=1,761 loops=1)

9. 0.083 0.377 ↓ 1.0 380 1

Hash (cost=38.19..38.19 rows=377 width=55) (actual time=0.377..0.377 rows=380 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 41kB
10. 0.083 0.294 ↓ 1.0 380 1

Hash Join (cost=25.23..38.19 rows=377 width=55) (actual time=0.192..0.294 rows=380 loops=1)

  • Hash Cond: (grpm.""GRPM_K_SITE_ID"" = site.""SITE_ID"")
11. 0.032 0.032 ↓ 1.0 380 1

Seq Scan on ""T_GROUPEMENT"" grpm (cost=0.00..7.77 rows=377 width=8) (actual time=0.010..0.032 rows=380 loops=1)

12. 0.073 0.179 ↓ 1.0 367 1

Hash (cost=20.66..20.66 rows=366 width=51) (actual time=0.179..0.179 rows=367 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
13. 0.106 0.106 ↓ 1.0 367 1

Seq Scan on ""T_SITE"" site (cost=0.00..20.66 rows=366 width=51) (actual time=0.035..0.106 rows=367 loops=1)

14. 0.009 0.039 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=240) (actual time=0.039..0.039 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
15. 0.030 0.030 ↑ 1.0 14 1

Seq Scan on ""T_PARAM_MODELE_VE"" pmve (cost=0.00..1.14 rows=14 width=240) (actual time=0.028..0.030 rows=14 loops=1)

Planning time : 0.654 ms
Execution time : 27,317.072 ms