explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1LMH

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

Sort (cost=5.33..5.33 rows=1 width=3,793) (actual rows= loops=)

  • Sort Key: bitcaster_channel.organization_id, bitcaster_application.name, bitcaster_application.id, bitcaster_channel.name
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.09..5.32 rows=1 width=3,793) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.96..4.82 rows=1 width=2,496) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.82..4.33 rows=1 width=1,197) (actual rows= loops=)

  • Hash Cond: (bitcaster_channel.id = bitcaster_event_channels.channel_id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on bitcaster_channel (cost=0.00..2.36 rows=36 width=1,197) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=1.81..1.81 rows=1 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on bitcaster_event_channels (cost=0.00..1.81 rows=1 width=4) (actual rows= loops=)

  • Filter: (event_id = 36)
8. 0.000 0.000 ↓ 0.0

Index Scan using bitcaster_organization_pkey on bitcaster_organization (cost=0.13..0.48 rows=1 width=1,299) (actual rows= loops=)

  • Index Cond: (bitcaster_channel.organization_id = id)
9. 0.000 0.000 ↓ 0.0

Index Scan using t1 on bitcaster_application (cost=0.14..0.49 rows=1 width=1,297) (actual rows= loops=)

  • Index Cond: (bitcaster_channel.application_id = id)