explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7NkJ

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

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

2.          

Initplan (forResult)

3. 0.001 0.322 ↑ 1.0 1 1

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

4. 0.321 0.321 ↑ 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.321..0.321 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))
Planning time : 0.598 ms
Execution time : 0.376 ms