explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rg3o

Settings
# exclusive inclusive rows x rows loops node
1. 0.403 1,472.714 ↓ 3.0 776 1

Limit (cost=0.55..1,454.10 rows=261 width=106) (actual time=21.354..1,472.714 rows=776 loops=1)

2. 1,472.311 1,472.311 ↓ 3.0 776 1

Index Scan using keystroke_graphs_idx on keystroke_graphs (cost=0.55..1,454.10 rows=261 width=106) (actual time=21.352..1,472.311 rows=776 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))
  • Filter: (octet_length(data) < 134217)
Planning time : 8.863 ms
Execution time : 1,472.986 ms