explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UQqI

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

GroupAggregate (cost=2,560.78..2,561.71 rows=50 width=68) (actual rows= loops=)

  • Group Key: mm.assetid
  • Filter: (count(modnodes.assetid) > 1)
2. 0.000 0.000 ↓ 0.0

Sort (cost=2,560.78..2,560.93 rows=57 width=8) (actual rows= loops=)

  • Sort Key: mm.assetid
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=693.27..2,559.12 rows=57 width=8) (actual rows= loops=)

  • Hash Cond: (ar.relatedassetid = modnodes.assetid)
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.56..1,866.18 rows=57 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

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

  • Filter: (assetdatatypeid = 20)
6. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=690.21..690.21 rows=200 width=4) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

HashAggregate (cost=686.21..688.21 rows=200 width=4) (actual rows= loops=)

  • Group Key: modnodes.assetid
9. 0.000 0.000 ↓ 0.0

Seq Scan on modnodes (cost=0.00..675.17 rows=4,417 width=4) (actual rows= loops=)