explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1mTu

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.273 ↑ 1.0 1 1

Limit (cost=0.85..16.91 rows=1 width=46) (actual time=0.272..0.273 rows=1 loops=1)

2. 0.002 0.272 ↑ 1.0 1 1

Nested Loop (cost=0.85..16.91 rows=1 width=46) (actual time=0.271..0.272 rows=1 loops=1)

3. 0.260 0.260 ↑ 1.0 1 1

Index Scan using kx_visit_actual_index1 on kx_visit_actual (cost=0.56..8.59 rows=1 width=46) (actual time=0.260..0.260 rows=1 loops=1)

  • Index Cond: ((customerid = '151438688590159390'::bigint) AND (userid = '1125224227880964096'::bigint))
  • Filter: ((actualvisittime >= '2019-05-11 00:00:00'::timestamp without time zone) AND (actualvisittime <= '2019-05-11 23:59:59'::timestamp without time zone) AND (customertype = '905324761813487616'::bigint))
  • Rows Removed by Filter: 78
4. 0.010 0.010 ↑ 1.0 1 1

Index Scan using pl_orgstruct_orgstructid on pl_orgstruct userid (cost=0.29..8.31 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (orgstructid = '1125224227880964096'::bigint)
  • Filter: (platstatus = 1)
Planning time : 0.481 ms
Execution time : 0.310 ms