explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uvH9

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

Nested Loop (cost=8.94..116.60 rows=29 width=35) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.66..106.57 rows=29 width=16) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.32..20.84 rows=4 width=16) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Only Scan using ""PK_AspNetUsers"" on ""AspNetUsers"" a (cost=0.14..8.15 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (""Id"" = '11c5eeed-d379-4df0-aecc-68bb87579eec'::text)
5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ""UserMonitoring"" u (cost=4.18..12.64 rows=4 width=48) (actual rows= loops=)

  • Recheck Cond: (""UserId"" = '11c5eeed-d379-4df0-aecc-68bb87579eec'::text)
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ""IX_UserMonitoring_UserId"" (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (""UserId"" = '11c5eeed-d379-4df0-aecc-68bb87579eec'::text)
7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ""PatentClassifications"" p (cost=4.34..21.36 rows=7 width=32) (actual rows= loops=)

  • Recheck Cond: (""PatentId"" = u.""PatentId"")
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ""IX_PatentClassifications_PatentId"" (cost=0.00..4.33 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (""PatentId"" = u.""PatentId"")
9. 0.000 0.000 ↓ 0.0

Index Scan using ""PK_Classifications"" on ""Classifications"" c (cost=0.28..0.35 rows=1 width=35) (actual rows= loops=)

  • Index Cond: (""Id"" = p.""ClassificationId"")