explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2jv9

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

Limit (cost=168.92..180.97 rows=1 width=44) (actual time=0.302..0.474 rows=1 loops=1)

2. 0.003 0.473 ↑ 1.0 1 1

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

3. 0.197 0.459 ↑ 1.0 1 1

Bitmap Heap Scan on kx_visit_customerstatus (cost=168.63..172.66 rows=1 width=44) (actual time=0.288..0.459 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.262 ↓ 0.0 0 1

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

5. 0.027 0.027 ↑ 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.027..0.027 rows=82 loops=1)

  • Index Cond: (customerid = '151438688590159390'::bigint)
6. 0.228 0.228 ↑ 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.228..0.228 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)