explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ViJR

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.085 ↑ 1.0 1 1

"Aggregate (cost=35,764.44..35,764.45 rows=1 width=8) (actual time=0.085..0.085 rows=1 loops=1)

2. 0.008 0.083 ↓ 0.0 0 1

Hash Join (cost=179.30..35,679.42 rows=6,801 width=2,019) (actual time=0.083..0.083 rows=0 loops=1)

  • Hash Cond: (ve.""VE_K_PMVE_ID"" = pmve.""PMVE_ID"")
3. 0.001 0.057 ↓ 0.0 0 1

Nested Loop (cost=177.98..35,587.69 rows=6,801 width=12) (actual time=0.057..0.057 rows=0 loops=1)

4. 0.056 0.056 ↓ 0.0 0 1

Index Scan using ""UNIQUE_T_VE_VE_MATRICULE"" on ""T_VE"" ve (cost=0.28..8.29 rows=1 width=8) (actual time=0.056..0.056 rows=0 loops=1)

  • Index Cond: ((""VE_MATRICULE"")::text = '1'::text)
5. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on ""T_EVENT_VE"" evve (cost=177.70..35,484.86 rows=9,454 width=12) (never executed)

  • Recheck Cond: (""EVVE_K_VE_ID"" = ve.""VE_ID"")
6. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ""INDEX_T_EVENT_VE_EVVE_K_VE_ID"" (cost=0.00..175.34 rows=9,454 width=0) (never executed)

  • Index Cond: (""EVVE_K_VE_ID"" = ve.""VE_ID"")
7. 0.008 0.018 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=4) (actual time=0.018..0.018 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.010 0.010 ↑ 1.0 14 1

Seq Scan on ""T_PARAM_MODELE_VE"" pmve (cost=0.00..1.14 rows=14 width=4) (actual time=0.009..0.010 rows=14 loops=1)

Planning time : 7.272 ms
Execution time : 0.157 ms