explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ha3

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

Hash Join (cost=44.30..88.85 rows=2,260 width=105) (actual rows= loops=)

  • Hash Cond: ("SupplierParts"."SupplierId" = "Suppliers"."Id")
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=22.15..60.73 rows=2,260 width=77) (actual rows= loops=)

  • Hash Cond: ("SupplierParts"."PartId" = "Parts"."Id")
3. 0.000 0.000 ↓ 0.0

Seq Scan on "SupplierParts" (cost=0.00..32.60 rows=2,260 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=15.40..15.40 rows=540 width=73) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on "Parts" (cost=0.00..15.40 rows=540 width=73) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=15.40..15.40 rows=540 width=36) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on "Suppliers" (cost=0.00..15.40 rows=540 width=36) (actual rows= loops=)