explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bzz4 : ///0

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

Subquery Scan on v_table (cost=455.96..462.46 rows=67 width=36) (actual rows= loops=)

  • Filter: (v_table.v < 3)
2. 0.000 0.000 ↓ 0.0

WindowAgg (cost=455.96..459.96 rows=200 width=48) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=455.96..456.46 rows=200 width=48) (actual rows= loops=)

  • Sort Key: people.class, (count(discipline.violation))
4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=446.32..448.32 rows=200 width=48) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Merge Join (cost=194.32..348.32 rows=9,800 width=48) (actual rows= loops=)

  • Merge Cond: (people.id = discipline.people_id)
6. 0.000 0.000 ↓ 0.0

Sort (cost=97.16..100.66 rows=1,400 width=28) (actual rows= loops=)

  • Sort Key: people.id
7. 0.000 0.000 ↓ 0.0

Seq Scan on people (cost=0.00..24.00 rows=1,400 width=28) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Sort (cost=97.16..100.66 rows=1,400 width=24) (actual rows= loops=)

  • Sort Key: discipline.people_id
9. 0.000 0.000 ↓ 0.0

Seq Scan on discipline (cost=0.00..24.00 rows=1,400 width=24) (actual rows= loops=)