explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DLmi

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

Nested Loop Left Join (cost=8.17..11.89 rows=1 width=4,041) (actual rows= loops=)

  • Join Filter: (bitcaster_occurence.application_id = bitcaster_application.id)
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.17..10.62 rows=1 width=2,744) (actual rows= loops=)

  • Join Filter: (bitcaster_occurence.organization_id = bitcaster_organization.id)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.17..9.53 rows=1 width=1,445) (actual rows= loops=)

  • Hash Cond: (bitcaster_event.id = bitcaster_occurence.event_id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on bitcaster_event (cost=0.00..1.25 rows=25 width=719) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=8.16..8.16 rows=1 width=726) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using test1 on bitcaster_occurence (cost=0.14..8.16 rows=1 width=726) (actual rows= loops=)

  • Index Cond: (id = 2)
7. 0.000 0.000 ↓ 0.0

Seq Scan on bitcaster_organization (cost=0.00..1.04 rows=4 width=1,299) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on bitcaster_application (cost=0.00..1.12 rows=12 width=1,297) (actual rows= loops=)