explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dISV

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

Limit (cost=168.92..180.97 rows=1 width=44) (actual time=0.504..1.219 rows=1 loops=1)

2. 0.003 1.218 ↑ 1.0 1 1

Nested Loop (cost=168.92..180.97 rows=1 width=44) (actual time=0.503..1.218 rows=1 loops=1)

3. 0.801 1.204 ↑ 1.0 1 1

Bitmap Heap Scan on kx_visit_customerstatus (cost=168.63..172.66 rows=1 width=44) (actual time=0.491..1.204 rows=1 loops=1)

  • Recheck Cond: ((customerid = '151438688590159390'::bigint) AND (userid = '1125224227880964096'::bigint))
  • Filter: ((visitdate >= '2019-05-11'::date) AND (visitdate <= '2019-05-11'::date) AND (platstatus = 1) AND (customertype = '905324761813487616'::bigint))
  • Rows Removed by Filter: 80
  • Heap Blocks: exact=82
4. 0.007 0.403 ↓ 0.0 0 1

BitmapAnd (cost=168.63..168.63 rows=1 width=0) (actual time=0.403..0.403 rows=0 loops=1)

5. 0.048 0.048 ↑ 1.2 82 1

Bitmap Index Scan on idx_kx_visit_customerstatus_customerid (cost=0.00..5.19 rows=101 width=0) (actual time=0.048..0.048 rows=82 loops=1)

  • Index Cond: (customerid = '151438688590159390'::bigint)
6. 0.348 0.348 ↑ 1.3 2,736 1

Bitmap Index Scan on idx_kx_visit_customerstatus_userid (cost=0.00..163.19 rows=3,567 width=0) (actual time=0.348..0.348 rows=2,736 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.011..0.011 rows=1 loops=1)

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