explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VHsB

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 22.624 ↑ 1.0 1 1

Limit (cost=1,433.68..1,433.69 rows=1 width=8) (actual time=22.623..22.624 rows=1 loops=1)

2. 0.013 22.621 ↑ 1.0 1 1

Aggregate (cost=1,433.68..1,433.69 rows=1 width=8) (actual time=22.621..22.621 rows=1 loops=1)

3. 22.608 22.608 ↑ 8.0 26 1

Seq Scan on valoracion_almacenes_report var (cost=0.00..1,433.16 rows=207 width=4) (actual time=22.596..22.608 rows=26 loops=1)

  • Filter: ((fecha_alta)::date = (now())::date)
  • Rows Removed by Filter: 41392
Planning time : 0.107 ms
Execution time : 22.665 ms