explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N3aa

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

Limit (cost=69.88..81.93 rows=1 width=56) (actual time=0.923..1.038 rows=1 loops=1)

2. 0.003 1.037 ↑ 1.0 1 1

Nested Loop (cost=69.88..81.93 rows=1 width=56) (actual time=0.922..1.037 rows=1 loops=1)

3. 0.691 1.022 ↑ 1.0 1 1

Bitmap Heap Scan on kx_visit_planvisit (cost=69.59..73.61 rows=1 width=56) (actual time=0.908..1.022 rows=1 loops=1)

  • Recheck Cond: ((customerid = '151438688590159390'::bigint) AND (userid = '1125224227880964096'::bigint))
  • Filter: ((plandate >= '2019-05-11'::date) AND (plandate <= '2019-05-11'::date) AND (platstatus = 1))
  • Rows Removed by Filter: 77
  • Heap Blocks: exact=78
4. 0.005 0.331 ↓ 0.0 0 1

BitmapAnd (cost=69.59..69.59 rows=1 width=0) (actual time=0.331..0.331 rows=0 loops=1)

5. 0.049 0.049 ↑ 1.0 78 1

Bitmap Index Scan on idx_kx_visit_planvisit_customerid (cost=0.00..5.03 rows=79 width=0) (actual time=0.049..0.049 rows=78 loops=1)

  • Index Cond: (customerid = '151438688590159390'::bigint)
6. 0.277 0.277 ↓ 1.2 3,120 1

Bitmap Index Scan on idx_kx_visit_planvisit_userid (cost=0.00..64.31 rows=2,650 width=0) (actual time=0.277..0.277 rows=3,120 loops=1)

  • Index Cond: (userid = '1125224227880964096'::bigint)
7. 0.012 0.012 ↑ 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.012 rows=1 loops=1)

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