explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2FkQ

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

Index Scan using keystroke_graphs_idx on keystroke_graphs (cost=0.56..10.90 rows=1 width=36) (actual time=48.596..48.596 rows=0 loops=1)

  • Index Cond: (((protocol)::text = 'ssh'::text) AND ((user_id)::text = 'ptest1035'::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 : 0.363 ms
Execution time : 48.615 ms