explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OeNb

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

Nested Loop (cost=0.01..302,076.59 rows=8,580,000 width=896) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.01..1,776.59 rows=85,800 width=608) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on event (cost=0.00..60.58 rows=858 width=384) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Function Scan on jsonb_to_recordset schedule_information (cost=0.01..1.00 rows=100 width=224) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Function Scan on jsonb_to_recordset location_information (cost=0.01..1.00 rows=100 width=128) (actual rows= loops=)