explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EGCn

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

GroupAggregate (cost=1,879.40..1,880.11 rows=1 width=36) (actual rows= loops=)

  • Group Key: ar.relatedassetid
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,879.40..1,880.09 rows=1 width=12) (actual rows= loops=)

  • Join Filter: (mm.assetid = aat.assetid)
3. 0.000 0.000 ↓ 0.0

Merge Join (cost=1,878.96..1,879.52 rows=1 width=20) (actual rows= loops=)

  • Merge Cond: (ar.relatedassetid = mz.assetid)
4. 0.000 0.000 ↓ 0.0

Sort (cost=1,866.12..1,866.21 rows=39 width=20) (actual rows= loops=)

  • Sort Key: ar.relatedassetid
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..1,865.09 rows=39 width=20) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on modmeters mm (cost=0.00..1,767.19 rows=57 width=12) (actual rows= loops=)

  • Filter: (assetdatatypeid = 430)
7. 0.000 0.000 ↓ 0.0

Index Only Scan using assetrelationship_unique_constraint on assetrelationship ar (cost=0.56..1.71 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((assetid = mm.assetid) AND (assetrelationshiptypeid = 11))
8. 0.000 0.000 ↓ 0.0

Sort (cost=12.85..13.02 rows=70 width=4) (actual rows= loops=)

  • Sort Key: mz.assetid
9. 0.000 0.000 ↓ 0.0

Seq Scan on modzones mz (cost=0.00..10.70 rows=70 width=4) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Only Scan using assetassettype_unique_constraint on assetassettype aat (cost=0.44..0.56 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (assetid = ar.assetid)
  • Filter: (assettypeid = ANY ('{3515,3530}'::integer[]))