explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1AFJ

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

Limit (cost=13.84..13.85 rows=1 width=44) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=13.84..13.85 rows=1 width=44) (actual rows= loops=)

  • Sort Key: lists_entries.created_at DESC NULLS LAST, lists_entries.id
3. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=1.43..13.83 rows=1 width=44) (actual rows= loops=)

  • Join Filter: (lists_entries.company_id = lists_entries_1.company_id)
4. 0.000 0.000 ↓ 0.0

Index Scan using lists_entries_organization_id_list_id_index on lists_entries (cost=0.43..4.45 rows=1 width=44) (actual rows= loops=)

  • Index Cond: ((organization_id = 1153) AND (list_id = 11000))
5. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=1.00..9.37 rows=1 width=4) (actual rows= loops=)

  • Join Filter: ((lists_entries_1.organization_id = entity_values.organization_id) AND (lists_entries_1.company_id = entity_values.company_id))
6. 0.000 0.000 ↓ 0.0

Index Scan using lists_entries_organization_id_list_id_index on lists_entries lists_entries_1 (cost=0.43..4.45 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((organization_id = 1153) AND (list_id = 11000))
7. 0.000 0.000 ↓ 0.0

Index Only Scan using entity_values_org_id_entity_attribute_id_company_id_index on entity_values (cost=0.56..4.71 rows=14 width=8) (actual rows= loops=)

  • Index Cond: ((organization_id = 1153) AND (entity_attribute_id = 95234))