explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p8nI

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

Limit (cost=0.85..16.91 rows=1 width=44) (actual time=0.118..0.280 rows=1 loops=1)

2. 0.001 0.279 ↑ 1.0 1 1

Nested Loop (cost=0.85..16.91 rows=1 width=44) (actual time=0.117..0.279 rows=1 loops=1)

3. 0.267 0.267 ↑ 1.0 1 1

Index Scan using kx_visit_customerstatus_index1 on kx_visit_customerstatus (cost=0.56..8.59 rows=1 width=44) (actual time=0.106..0.267 rows=1 loops=1)

  • Index Cond: ((customerid = '151438688590159390'::bigint) AND (userid = '1125224227880964096'::bigint))
  • Filter: ((visitdate >= '2019-05-11'::date) AND (visitdate <= '2019-05-11'::date) AND (customertype = '905324761813487616'::bigint))
  • Rows Removed by Filter: 80
4. 0.011 0.011 ↑ 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.011 rows=1 loops=1)

  • Index Cond: (orgstructid = '1125224227880964096'::bigint)
  • Filter: (platstatus = 1)