explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ptjH

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

Index Scan using keystroke_graphs_idx on keystroke_graphs (cost=0.56..10.90 rows=1 width=36) (actual time=0.030..0.030 rows=0 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 : 0.372 ms
Execution time : 0.047 ms