explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8McE

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 2.559 ↓ 2.0 2 1

Limit (cost=145.53..145.53 rows=1 width=24) (actual time=2.557..2.559 rows=2 loops=1)

2. 0.049 2.556 ↓ 2.0 2 1

Sort (cost=145.53..145.53 rows=1 width=24) (actual time=2.555..2.556 rows=2 loops=1)

  • Sort Key: visittime DESC
  • Sort Method: quicksort Memory: 25kB
3. 1.381 2.507 ↓ 2.0 2 1

Bitmap Heap Scan on kx_visit_workrecord (cost=141.49..145.52 rows=1 width=24) (actual time=2.249..2.507 rows=2 loops=1)

  • Recheck Cond: ((customerid = '151438688590159390'::bigint) AND (userid = '1125224227880964096'::bigint))
  • Filter: ((recorddate >= '2019-05-11'::date) AND (recorddate <= '2019-05-11'::date) AND (customertype = '905324761813487616'::bigint) AND ((visitcontent)::text = '离店签退'::text) AND (platstatus = 1))
  • Rows Removed by Filter: 189
  • Heap Blocks: exact=170
4. 0.025 1.126 ↓ 0.0 0 1

BitmapAnd (cost=141.49..141.49 rows=1 width=0) (actual time=1.126..1.126 rows=0 loops=1)

5. 0.075 0.075 ↓ 1.2 191 1

Bitmap Index Scan on idx_kx_visit_workrecord_customerid (cost=0.00..5.68 rows=166 width=0) (actual time=0.075..0.075 rows=191 loops=1)

  • Index Cond: (customerid = '151438688590159390'::bigint)
6. 1.026 1.026 ↓ 1.1 6,552 1

Bitmap Index Scan on idx_kx_visit_workrecord_userid (cost=0.00..135.56 rows=5,749 width=0) (actual time=1.026..1.026 rows=6,552 loops=1)

  • Index Cond: (userid = '1125224227880964096'::bigint)
Planning time : 0.826 ms
Execution time : 2.643 ms