explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1F7cV : index on UUID added plan #dPZm

Settings

Optimization path:

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

Limit (cost=0.43..2.65 rows=1 width=4) (actual time=0.015..0.016 rows=1 loops=1)

2. 0.014 0.014 ↑ 1.0 1 1

Index Only Scan using uuid_idx on mailer_notifications (cost=0.43..2.65 rows=1 width=4) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: (uuid = '0666e842-8492-419e-9f2a-ede0df57f23a'::uuid)
  • Heap Fetches: 1
Planning time : 0.157 ms
Execution time : 0.037 ms