explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hky6

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.210 ↑ 1.0 1 1

Limit (cost=8.60..8.61 rows=1 width=24) (actual time=0.209..0.210 rows=1 loops=1)

2. 0.025 0.208 ↑ 1.0 1 1

Sort (cost=8.60..8.61 rows=1 width=24) (actual time=0.208..0.208 rows=1 loops=1)

  • Sort Key: visittime DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.183 0.183 ↑ 1.0 1 1

Index Scan using kx_visit_workrecord_index2 on kx_visit_workrecord (cost=0.56..8.59 rows=1 width=24) (actual time=0.096..0.183 rows=1 loops=1)

  • Index Cond: ((customerid = '634015349354193800'::bigint) AND (userid = '1125224227759329280'::bigint) AND ((visitcontent)::text = '进店签到'::text) AND (customertype = '905324761813487616'::bigint))
  • Filter: ((recorddate >= '2019-05-15'::date) AND (recorddate <= '2019-05-15'::date))
  • Rows Removed by Filter: 12
Planning time : 0.734 ms
Execution time : 0.243 ms