explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wOsK

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.156 ↑ 1.0 1 1

Aggregate (cost=114.08..114.09 rows=1 width=0) (actual time=0.156..0.156 rows=1 loops=1)

2. 0.003 0.152 ↑ 1.0 1 1

Limit (cost=0.56..114.07 rows=1 width=0) (actual time=0.151..0.152 rows=1 loops=1)

3. 0.149 0.149 ↑ 4,733.0 1 1

Index Scan using xix_clnt_ct_tm_pmnt_ctns on client_actions ca (cost=0.56..537,227.38 rows=4,733 width=0) (actual time=0.149..0.149 rows=1 loops=1)

  • Index Cond: ((client_id = '7470'::numeric) AND (act_time >= '2019-03-24 00:00:00'::timestamp without time zone) AND (act_time < '2019-05-23 15:11:02.449'::timestamp without time zone))
  • Filter: ((conclusion = 2) AND (request_ip = '3249701633'::numeric))
  • Rows Removed by Filter: 15
Planning time : 0.590 ms
Execution time : 0.244 ms