explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XrMd

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

Nested Loop (cost=8.83..14.55 rows=10 width=501) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.69..12.78 rows=10 width=61) (actual rows= loops=)

  • Hash Cond: (auth_permission.id = authentication_user_user_permissions.permission_id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on auth_permission (cost=0.00..3.64 rows=164 width=49) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=8.57..8.57 rows=10 width=12) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on authentication_user_user_permissions (cost=1.33..8.57 rows=10 width=12) (actual rows= loops=)

  • Recheck Cond: (user_id = 2)
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on authentication_user_user_permissions_user_id_736ebf7e (cost=0.00..1.33 rows=10 width=0) (actual rows= loops=)

  • Index Cond: (user_id = 2)
7. 0.000 0.000 ↓ 0.0

Index Scan using django_content_type_pkey on django_content_type (cost=0.14..0.18 rows=1 width=440) (actual rows= loops=)

  • Index Cond: (id = auth_permission.content_type_id)