explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X9bx

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

Limit (cost=0.55..8.58 rows=1 width=451) (actual time=0.024..0.025 rows=1 loops=1)

2. 0.023 0.023 ↑ 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.022..0.023 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 : 0.987 ms
Execution time : 0.057 ms