explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N9cD

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.039 ↑ 1.0 1 1

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

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

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

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

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

  • Filter: ((deleted_at IS NULL) AND (model_uuid = '540f0aa6-d5c7-3c5e-9b4c-bc5cde0a84cf'::uuid) AND ((model_type)::text = 'user'::text))
  • Rows Removed by Filter: 6
Planning time : 0.191 ms
Execution time : 0.060 ms