explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YROi

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..2.19 rows=1 width=1,668) (actual rows= loops=)

  • Join Filter: (roles.uuid = model_has_roles.role_uuid)
2. 0.000 0.000 ↓ 0.0

Seq Scan on roles (cost=0.00..1.03 rows=1 width=1,072) (actual rows= loops=)

  • Filter: (deleted_at IS NULL)
3. 0.000 0.000 ↓ 0.0

Seq Scan on model_has_roles (cost=0.00..1.15 rows=1 width=596) (actual rows= loops=)

  • Filter: ((deleted_at IS NULL) AND (model_uuid = '540f0aa6-d5c7-3c5e-9b4c-bc5cde0a84cf'::uuid) AND ((model_type)::text = 'user'::text))