explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yeG7

Settings

Optimization(s) for this plan:

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

GroupAggregate (cost=21.51..21.56 rows=1 width=2,164) (actual rows= loops=)

  • Group Key: va.violation_id, v.name, v.cveids, v.severity, v.classification, v.release_date, v.type
2. 0.000 0.000 ↓ 0.0

Sort (cost=21.51..21.51 rows=1 width=2,636) (actual rows= loops=)

  • Sort Key: va.violation_id, v.name, v.cveids, v.severity, v.classification, v.release_date, v.type
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..21.50 rows=1 width=2,636) (actual rows= loops=)

  • Join Filter: (va.violation_id = v.violation_id)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.14..19.15 rows=1 width=548) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on violation_assets va (cost=0.00..10.98 rows=1 width=16) (actual rows= loops=)

  • Filter: ((state <> ALL ('{20,21,22,23,24,25,26,27}'::integer[])) AND ('" + security_groups + "'::text = ANY (security_groups)))
6. 0.000 0.000 ↓ 0.0

Index Scan using violation_assets_uindx on violation_assets v2 (cost=0.14..8.16 rows=1 width=532) (actual rows= loops=)

  • Index Cond: (violation_id = va.violation_id)
  • Filter: (state <> ALL ('{20,21,22,23,24,25,26,27}'::integer[]))
7. 0.000 0.000 ↓ 0.0

Index Scan using violations_pkey on violations v (cost=0.14..2.34 rows=1 width=2,120) (actual rows= loops=)

  • Index Cond: (violation_id = v2.violation_id)