explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cgGn : ct

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

Gather Merge (cost=16,819.37..26,807.90 rows=85,610 width=380) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Sort (cost=15,819.34..15,926.35 rows=42,805 width=380) (actual rows= loops=)

  • Sort Key: asset.id
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10.71..5,064.46 rows=42,805 width=380) (actual rows= loops=)

  • Hash Cond: (category.parent_id = t3.id)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=5.35..4,943.95 rows=42,805 width=351) (actual rows= loops=)

  • Hash Cond: (asset.category_id = category.id)
5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on asset (cost=0.00..4,823.05 rows=42,805 width=322) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=3.49..3.49 rows=149 width=29) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on category (cost=0.00..3.49 rows=149 width=29) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=3.49..3.49 rows=149 width=29) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on category t3 (cost=0.00..3.49 rows=149 width=29) (actual rows= loops=)