explain.depesz.com

PostgreSQL's explain analyze made readable

Result: If2D

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

Aggregate (cost=1,358.67..1,358.68 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan using command_count_user_id_idx on command_count (cost=0.56..1,355.10 rows=715 width=748) (actual rows= loops=)

  • Index Cond: (((connection_policy_id)::text = ANY ('{724cc18c-4aee-40a3-8a25-1c4e47f8c569,dcecabe7-66b5-4c46-9746-1fed30c74abe}'::text[])) AND ((user_id)::text = 'ptest2501'::text) AND ("timestamp" <= 1562837073) AND ("timestamp" >= 1555061073))
Execution time : 7,482.204 ms