explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y7VL

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

Limit (cost=0.56..10.90 rows=1 width=36) (actual time=39.514..39.514 rows=0 loops=1)

2. 39.513 39.513 ↓ 0.0 0 1

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

  • Index Cond: (((protocol)::text = 'ssh'::text) AND ((user_id)::text = 'ptest0035'::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.231 ms
Execution time : 39.526 ms