explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f78k

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

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

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

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

3. 0.029 0.093 ↓ 0.0 0 1

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

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

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

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

Nested Loop (cost=177.98..35,587.69 rows=6,801 width=863) (actual time=0.025..0.025 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.009 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.012 0.012 ↑ 1.0 14 1

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

Planning time : 3.764 ms
Execution time : 0.313 ms