explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ydo3

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.407 ↑ 1.0 1 1

Aggregate (cost=342.27..342.28 rows=1 width=0) (actual time=0.406..0.407 rows=1 loops=1)

2. 0.237 0.402 ↑ 1.0 3 1

Append (cost=0.56..342.26 rows=3 width=0) (actual time=0.165..0.402 rows=3 loops=1)

3. 0.000 0.165 ↑ 1.0 1 1

Subquery Scan on *SELECT* 1 (cost=0.56..114.09 rows=1 width=0) (actual time=0.165..0.165 rows=1 loops=1)

4. 0.001 0.163 ↑ 1.0 1 1

Limit (cost=0.56..114.08 rows=1 width=0) (actual time=0.163..0.163 rows=1 loops=1)

5. 0.162 0.162 ↑ 4,733.0 1 1

Index Scan using xix_clnt_ct_tm_pmnt_ctns on client_actions ca (cost=0.56..537,247.50 rows=4,733 width=0) (actual time=0.162..0.162 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
6. 0.001 0.114 ↑ 1.0 1 1

Subquery Scan on *SELECT* 2 (cost=0.56..114.09 rows=1 width=0) (actual time=0.113..0.114 rows=1 loops=1)

7. 0.000 0.113 ↑ 1.0 1 1

Limit (cost=0.56..114.08 rows=1 width=0) (actual time=0.113..0.113 rows=1 loops=1)

8. 0.113 0.113 ↑ 4,733.0 1 1

Index Scan using xix_clnt_ct_tm_pmnt_ctns on client_actions ca_1 (cost=0.56..537,247.50 rows=4,733 width=0) (actual time=0.113..0.113 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
9. 0.000 0.119 ↑ 1.0 1 1

Subquery Scan on *SELECT* 3 (cost=0.56..114.09 rows=1 width=0) (actual time=0.118..0.119 rows=1 loops=1)

10. 0.001 0.119 ↑ 1.0 1 1

Limit (cost=0.56..114.08 rows=1 width=0) (actual time=0.118..0.119 rows=1 loops=1)

11. 0.118 0.118 ↑ 4,733.0 1 1

Index Scan using xix_clnt_ct_tm_pmnt_ctns on client_actions ca_2 (cost=0.56..537,247.50 rows=4,733 width=0) (actual time=0.118..0.118 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 : 1.397 ms
Execution time : 0.547 ms