explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7az

Settings
# exclusive inclusive rows x rows loops node
1. 0.185 9.648 ↓ 1.0 812 1

Limit (cost=0.55..1,447.10 rows=789 width=70) (actual time=0.122..9.648 rows=812 loops=1)

2. 9.463 9.463 ↓ 1.0 812 1

Index Scan using keystroke_graphs_idx2 on keystroke_graphs (cost=0.55..1,447.10 rows=789 width=70) (actual time=0.120..9.463 rows=812 loops=1)

  • Index Cond: (((protocol)::text = 'ssh'::text) AND ((user_id)::text = 'ptest2035'::text) AND ((connection_policy_id)::text = ANY ('{2b14a9b7-ed98-4477-b038-a9528468c35f,902b5107-eaf4-4999-a664-38f5656ac8c0}'::text[])) AND ("timestamp" <= 1562590441) AND ("timestamp" >= 1554814441))
Planning time : 1.238 ms
Execution time : 9.775 ms