explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fhv

Settings
# exclusive inclusive rows x rows loops node
1. 383.433 1,259.917 ↑ 1.0 1 1

Aggregate (cost=1,040,727.61..1,040,727.62 rows=1 width=0) (actual time=1,259.916..1,259.917 rows=1 loops=1)

2. 876.484 876.484 ↑ 1.9 789,787 1

Index Only Scan using index_action_states_state_timestamp3 on action_states (cost=0.01..1,037,002.33 rows=1,490,111 width=0) (actual time=0.069..876.484 rows=789,787 loops=1)

  • Index Cond: ((state = 'reg'::text) AND ("timestamp" >= ((now())::timestamp without time zone - '7 days'::interval)))
  • Heap Fetches: 582357
Total runtime : 1,259.950 ms