explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E4Uy

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.039 ↓ 0.0 0 1

Limit (cost=5.51..5.51 rows=1 width=107) (actual time=0.039..0.039 rows=0 loops=1)

2. 0.005 0.038 ↓ 0.0 0 1

Sort (cost=5.51..5.52 rows=4 width=107) (actual time=0.038..0.038 rows=0 loops=1)

  • Sort Key: checkin_date DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.033 0.033 ↓ 0.0 0 1

Index Scan using member_id_idx on "checkIn" (cost=0.42..5.49 rows=4 width=107) (actual time=0.033..0.033 rows=0 loops=1)

  • Index Cond: (member_id = '4882283a-ff3f-4282-b3d0-4714f46e3280'::uuid)
  • Filter: (NOT obsolete_flag)