explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PPt

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

GroupAggregate (cost=28,276,846.11..29,333,057.23 rows=961,645 width=63) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=28,276,846.11..28,485,203.40 rows=83,342,916 width=63) (actual rows= loops=)

  • Sort Key: g.group_name, g.category_name, (date_part('year'::text, (mbs.service_date)::timestamp without time zone))
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=6,344.92..1,644,515.29 rows=83,342,916 width=63) (actual rows= loops=)

  • Hash Cond: (mbs.item = (mbs_imap.item)::bpchar)
4. 0.000 0.000 ↓ 0.0

Seq Scan on mbs (cost=0.00..188,084.24 rows=7,624,024 width=10) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=3,042.40..3,042.40 rows=136,361 width=65) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=4.09..3,042.40 rows=136,361 width=65) (actual rows= loops=)

  • Hash Cond: (mbs_imap.mbs_cat = g.mbs_cat)
7. 0.000 0.000 ↓ 0.0

Seq Scan on mbs_imap (cost=0.00..1,175.74 rows=12,474 width=10) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=2.93..2.93 rows=93 width=63) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on cat_group g (cost=0.00..2.93 rows=93 width=63) (actual rows= loops=)