explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vtbc

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

GroupAggregate (cost=111,694,647.59..117,336,384.17 rows=11,840,946 width=176) (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=111,694,647.59..112,291,904.85 rows=238,902,902 width=155) (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

Hash Join (cost=103,206.20..3,325,323.96 rows=238,902,902 width=155) (actual rows= loops=)

  • Hash Cond: (va2.violation_id = va.violation_id)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=465.18..92,197.68 rows=746,046 width=171) (actual rows= loops=)

  • Hash Cond: (va2.violation_id = v.violation_id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on violation_assets va2 (cost=0.00..89,772.44 rows=746,046 width=39) (actual rows= loops=)

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

Hash (cost=403.97..403.97 rows=4,897 width=132) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on violations v (cost=0.00..403.97 rows=4,897 width=132) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=89,772.44..89,772.44 rows=746,046 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on violation_assets va (cost=0.00..89,772.44 rows=746,046 width=16) (actual rows= loops=)

  • Filter: (state <> ALL ('{20,21,22,23,24,25,26,27}'::integer[]))