explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LvnC

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.104 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.15 rows=1 width=1,668) (actual time=0.101..0.104 rows=1 loops=1)

  • Join Filter: (roles.uuid = model_has_roles.role_uuid)
  • Rows Removed by Join Filter: 2
2. 0.062 0.062 ↓ 3.0 3 1

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

  • Filter: (deleted_at IS NULL)
3. 0.036 0.036 ↑ 1.0 1 3

Seq Scan on model_has_roles (cost=0.00..1.10 rows=1 width=596) (actual time=0.011..0.012 rows=1 loops=3)

  • Filter: ((deleted_at IS NULL) AND (model_uuid = '2f47595c-ca50-38f3-9325-0d613ef48cf9'::uuid) AND ((model_type)::text = 'user'::text))
  • Rows Removed by Filter: 4
Planning time : 0.238 ms
Execution time : 0.128 ms