explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HMfc

Settings

Optimization(s) for this plan:

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

GroupAggregate (cost=59,652,439.90..63,778,624.11 rows=14,401,353 width=111) (actual rows= loops=)

  • Group Key: (date_trunc('hour'::text, "timestamp")), accessor, request_method, status
2. 0.000 0.000 ↓ 0.0

Sort (cost=59,652,439.90..60,036,255.62 rows=153,526,286 width=87) (actual rows= loops=)

  • Sort Key: (date_trunc('hour'::text, "timestamp")), accessor, request_method, status
3. 0.000 0.000 ↓ 0.0

Seq Scan on ahe_atlanta_2019_09_29 (cost=0.00..31,431,064.04 rows=153,526,286 width=87) (actual rows= loops=)

  • Filter: (vault_name = 'active'::text)