explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BhEFG

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.086 ↓ 0.0 0 1

"Subquery Scan on vequery (cost=38,716.36..38,937.39 rows=34 width=877) (actual time=0.085..0.086 rows=0 loops=1)

  • Filter: ((vequery.rownum >= 1) AND (vequery.rownum <= 1000))
2. 0.003 0.085 ↓ 0.0 0 1

WindowAgg (cost=38,716.36..38,835.38 rows=6,801 width=877) (actual time=0.085..0.085 rows=0 loops=1)

3. 0.025 0.082 ↓ 0.0 0 1

Sort (cost=38,716.36..38,733.36 rows=6,801 width=869) (actual time=0.082..0.082 rows=0 loops=1)

  • Sort Key: evve.""EVVE_DATE_EVENT"" DESC
  • Sort Method: quicksort Memory: 25kB
4. 0.010 0.057 ↓ 0.0 0 1

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

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

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

6. 0.025 0.025 ↓ 0.0 0 1

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

  • Index Cond: ((""VE_MATRICULE"")::text = 'matricule'::text)
7. 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=751) (never executed)

  • Recheck Cond: (""EVVE_K_VE_ID"" = ve.""VE_ID"")
8. 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"")
9. 0.011 0.021 ↑ 1.0 14 1

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

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

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

Planning time : 4.199 ms
Execution time : 0.241 ms