explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tF6v

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.247 ↑ 1.0 1 1

Limit (cost=110.59..110.60 rows=1 width=4) (actual time=0.247..0.247 rows=1 loops=1)

2.          

Initplan (forLimit)

3. 0.001 0.243 ↑ 1.0 1 1

Limit (cost=0.29..110.59 rows=1 width=4) (actual time=0.243..0.243 rows=1 loops=1)

4. 0.242 0.242 ↑ 207.0 1 1

Index Scan Backward using var_cv_idx on valoracion_almacenes_report var (cost=0.29..22,831.85 rows=207 width=4) (actual time=0.242..0.242 rows=1 loops=1)

  • Index Cond: (cod_valoracion IS NOT NULL)
  • Filter: (to_date((fecha_alta)::text, 'dd/mm/yyyy'::text) = to_date((now())::text, 'dd/mm/yyyy'::text))
5. 0.246 0.246 ↑ 1.0 1 1

Result (cost=110.59..110.60 rows=1 width=4) (actual time=0.246..0.246 rows=1 loops=1)

Planning time : 0.543 ms
Execution time : 0.286 ms