explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ubEW

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

Hash Join (cost=1.23..3.86 rows=5 width=129) (actual rows= loops=)

  • Hash Cond: (ra."ReportAssetCategoryId" = rac."Id")
2. 0.000 0.000 ↓ 0.0

Seq Scan on "ReportAssets" ra (cost=0.00..2.63 rows=5 width=16) (actual rows= loops=)

  • Filter: ("ReportOperationType" = 12)
3. 0.000 0.000 ↓ 0.0

Hash (cost=1.10..1.10 rows=10 width=129) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on "ReportAssetCategories" rac (cost=0.00..1.10 rows=10 width=129) (actual rows= loops=)