explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5KY4 : Optimization for: plan with index

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.003 0.033 ↑ 1.0 1 1

Limit (cost=0.55..8.58 rows=1 width=451) (actual time=0.032..0.033 rows=1 loops=1)

2. 0.030 0.030 ↑ 1.0 1 1

Index Scan using notificatins_name_user_company_idx on notifications (cost=0.55..8.58 rows=1 width=451) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: (((company_uuid)::text = 'b7fa583e-a144-4ec2-9464-e1e514512fb4'::text) AND ((name)::text = 'ACTIVITY_ASSIGNATION'::text) AND ((user_uuid)::text = '5a988be1-5c8c-470a-9e8c-0bb42dbf8702'::text) AND ((notification_type)::text = 'EMAIL'::text) AND ((activity_uuid)::text = '4294be3c-ee9a-4388-b62c-84b6ab2bbbec'::text))
Planning time : 4.801 ms
Execution time : 0.497 ms