explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xDyw

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

Limit (cost=69.88..81.93 rows=1 width=56) (actual time=0.380..0.410 rows=1 loops=1)

2. 0.002 0.409 ↑ 1.0 1 1

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

3. 0.177 0.396 ↑ 1.0 1 1

Bitmap Heap Scan on kx_visit_planvisit (cost=69.59..73.61 rows=1 width=56) (actual time=0.367..0.396 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.006 0.219 ↓ 0.0 0 1

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

5. 0.025 0.025 ↑ 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.025..0.025 rows=78 loops=1)

  • Index Cond: (customerid = '151438688590159390'::bigint)
6. 0.188 0.188 ↓ 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.188..0.188 rows=3,120 loops=1)

  • Index Cond: (userid = '1125224227880964096'::bigint)
7. 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)