explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Nnb

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

Limit (cost=69.88..81.94 rows=1 width=46) (actual time=1.088..1.090 rows=1 loops=1)

2. 0.003 1.089 ↑ 1.0 1 1

Nested Loop (cost=69.88..81.94 rows=1 width=46) (actual time=1.087..1.089 rows=1 loops=1)

3. 0.773 1.074 ↑ 1.0 1 1

Bitmap Heap Scan on kx_visit_actual (cost=69.60..73.62 rows=1 width=46) (actual time=1.073..1.074 rows=1 loops=1)

  • Recheck Cond: ((customerid = '151438688590159390'::bigint) AND (userid = '1125224227880964096'::bigint))
  • Filter: ((actualvisittime >= '2019-05-11 00:00:00'::timestamp without time zone) AND (actualvisittime <= '2019-05-11 23:59:59'::timestamp without time zone) AND (platstatus = 1) AND (customertype = '905324761813487616'::bigint))
  • Rows Removed by Filter: 78
  • Heap Blocks: exact=80
4. 0.005 0.301 ↓ 0.0 0 1

BitmapAnd (cost=69.60..69.60 rows=1 width=0) (actual time=0.301..0.301 rows=0 loops=1)

5. 0.046 0.046 ↓ 1.1 80 1

Bitmap Index Scan on idx_kx_visit_actual_customerid (cost=0.00..5.00 rows=76 width=0) (actual time=0.046..0.046 rows=80 loops=1)

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

Bitmap Index Scan on idx_kx_visit_actual_userid (cost=0.00..64.34 rows=2,654 width=0) (actual time=0.250..0.250 rows=3,123 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.012..0.012 rows=1 loops=1)

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