explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b0Qd

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1.880 ↓ 2.0 2 1

Limit (cost=145.07..145.07 rows=1 width=24) (actual time=1.879..1.880 rows=2 loops=1)

2. 0.014 1.879 ↓ 2.0 2 1

Sort (cost=145.07..145.07 rows=1 width=24) (actual time=1.878..1.879 rows=2 loops=1)

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

Bitmap Heap Scan on kx_visit_workrecord (cost=141.03..145.06 rows=1 width=24) (actual time=1.739..1.865 rows=2 loops=1)

  • Recheck Cond: ((customerid = '201146068148709630'::bigint) AND (userid = '1125224228375891968'::bigint))
  • Filter: ((recorddate >= '2019-05-10'::date) AND (recorddate <= '2019-05-10'::date) AND (customertype = '905324761813487616'::bigint) AND ((visitcontent)::text = '离店签退'::text) AND (platstatus = 1))
  • Rows Removed by Filter: 179
  • Heap Blocks: exact=160
4. 0.010 0.848 ↓ 0.0 0 1

BitmapAnd (cost=141.03..141.03 rows=1 width=0) (actual time=0.848..0.848 rows=0 loops=1)

5. 0.053 0.053 ↓ 1.1 181 1

Bitmap Index Scan on idx_kx_visit_workrecord_customerid (cost=0.00..5.67 rows=164 width=0) (actual time=0.053..0.053 rows=181 loops=1)

  • Index Cond: (customerid = '201146068148709630'::bigint)
6. 0.785 0.785 ↓ 1.2 6,549 1

Bitmap Index Scan on idx_kx_visit_workrecord_userid (cost=0.00..135.11 rows=5,690 width=0) (actual time=0.785..0.785 rows=6,549 loops=1)

  • Index Cond: (userid = '1125224228375891968'::bigint)