explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 27DA

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

XN HashAggregate (cost=1,399,079.04..1,399,310.87 rows=46,366 width=1,608) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

XN Seq Scan on inventory_vs_demand (cost=0.00..1,390,965.06 rows=463,656 width=1,608) (actual rows= loops=)

  • Filter: ((date_of_calculations <= '2020-02-02 00:00:00'::timestamp without time zone) AND (date_of_calculations >= '2020-01-01 00:00:00'::timestamp without time zone))