explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oa8a

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

Bitmap Heap Scan on weight weight (cost=168,060.42..5,197,095.26 rows=5,411,888 width=77) (never executed)

2. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on weight_last_updated_idx (cost=0..166,707.45 rows=5,411,888 width=0) (never executed)

  • Index Cond: ((last_updated > '2017-01-01 00:00:00'::timestamp without time zone) AND (last_updated < '2017-02-01 00:00:00'::timestamp without time zone))