explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qUIV

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

Limit (cost=1.20..1.20 rows=1 width=95) (actual time=0.012..0.013 rows=1 loops=1)

2. 0.005 0.011 ↑ 1.0 1 1

Sort (cost=1.20..1.20 rows=1 width=95) (actual time=0.011..0.011 rows=1 loops=1)

  • Sort Key: created_date DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on maintenance_tracker "maintenanceTracker" (cost=0.00..1.19 rows=1 width=95) (actual time=0.005..0.006 rows=1 loops=1)

  • Filter: (member_id = '615aa6fe-7dcc-4088-8ad9-c93f891f79db'::uuid)
  • Rows Removed by Filter: 16