explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TSKL

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.295 ↑ 1.0 1 1

Limit (cost=0.85..16.90 rows=1 width=56) (actual time=0.267..0.295 rows=1 loops=1)

2. 0.002 0.293 ↑ 1.0 1 1

Nested Loop (cost=0.85..16.90 rows=1 width=56) (actual time=0.266..0.293 rows=1 loops=1)

3. 0.280 0.280 ↑ 1.0 1 1

Index Scan using kx_visit_planvisit_index1 on kx_visit_planvisit (cost=0.56..8.59 rows=1 width=56) (actual time=0.253..0.280 rows=1 loops=1)

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

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