explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9IF7

Settings
# exclusive inclusive rows x rows loops node
1. 373.311 1,276.585 ↑ 1.0 1 1

Aggregate (cost=1,053,550.15..1,053,550.16 rows=1 width=0) (actual time=1,276.585..1,276.585 rows=1 loops=1)

2. 903.274 903.274 ↑ 1.9 789,422 1

Index Only Scan using index_action_states_state_timestamp3 on action_states (cost=0.01..1,049,766.59 rows=1,513,421 width=0) (actual time=0.085..903.274 rows=789,422 loops=1)

  • Index Cond: ((state = 'reg'::text) AND ("timestamp" >= (now() - '7 days'::interval)))
  • Heap Fetches: 581264
Total runtime : 1,276.616 ms