explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fg9V

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

Unique (cost=4,091.09..4,099.79 rows=290 width=266) (actual rows= loops=)

2.          

Initplan (forUnique)

3. 0.000 0.000 ↓ 0.0

Seq Scan on cacs cacs_1 (cost=0.00..3.08 rows=1 width=5) (actual rows= loops=)

  • Filter: ((cac)::text = '00/RP/BASELINE'::text)
4. 0.000 0.000 ↓ 0.0

Seq Scan on cacs cacs_1_1 (cost=0.00..3.08 rows=1 width=5) (actual rows= loops=)

  • Filter: ((cac)::text = '00/RP/BASELINE'::text)
5. 0.000 0.000 ↓ 0.0

Sort (cost=4,084.94..4,085.67 rows=290 width=266) (actual rows= loops=)

  • Sort Key: events.start_event, events.event_id, events.end_event, events.description, events.cac, (to_char(cacs.ccdf, '9.999EEEE'::text)), (to_char((cacs.ccdf / $0), 'FM999999999.00'::text)), (to_char(cacs.clerf, '9.999EEEE'::text)), (to_char((cacs.clerf / $1), 'FM999999999.00'::text)), ((SubPlan 3)), ((SubPlan 4))
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.93..4,073.08 rows=290 width=266) (actual rows= loops=)

  • Hash Cond: ((events.cac)::text = (cacs.cac)::text)
7. 0.000 0.000 ↓ 0.0

Seq Scan on events (cost=0.00..6.90 rows=290 width=74) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=2.86..2.86 rows=86 width=21) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on cacs (cost=0.00..2.86 rows=86 width=21) (actual rows= loops=)

10.          

SubPlan (forHash Join)

11. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.00..7.00 rows=1 width=36) (actual rows= loops=)

  • Group Key: categories.event_id
12. 0.000 0.000 ↓ 0.0

Seq Scan on categories (cost=0.00..6.97 rows=1 width=8) (actual rows= loops=)

  • Filter: (events.event_id = event_id)
13. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.00..7.00 rows=1 width=36) (actual rows= loops=)

  • Group Key: categories_1.event_id
14. 0.000 0.000 ↓ 0.0

Seq Scan on categories categories_1 (cost=0.00..6.97 rows=1 width=15) (actual rows= loops=)

  • Filter: (events.event_id = event_id)