explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wg6m

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 48.399 ↑ 1.0 1 1

Limit (cost=41.70..41.71 rows=1 width=8) (actual time=48.399..48.399 rows=1 loops=1)

2. 0.010 48.398 ↑ 1.0 1 1

Aggregate (cost=41.70..41.71 rows=1 width=8) (actual time=48.398..48.398 rows=1 loops=1)

3. 1.190 48.388 ↓ 33.0 33 1

Nested Loop Semi Join (cost=1.57..41.69 rows=1 width=44) (actual time=1.341..48.388 rows=33 loops=1)

4. 0.000 41.324 ↓ 1,958.0 1,958 1

Nested Loop Semi Join (cost=1.01..25.07 rows=1 width=4) (actual time=0.596..41.324 rows=1,958 loops=1)

5. 5.563 5.563 ↓ 13,769.0 13,769 1

Index Scan using lists_entries_org_id_list_id_index on lists_entries (cost=0.43..8.46 rows=1 width=8) (actual time=0.014..5.563 rows=13,769 loops=1)

  • Index Cond: ((org_id = 4,796) AND (list_id = 26,657))
6. 625,456.825 625,456.825 ↓ 0.0 0 13,769

Index Scan using entity_values_org_id_entity_attribute_id_company_id_index on entity_values (cost=0.57..8.59 rows=1 width=4) (actual time=0.029..45.425 rows=0 loops=13,769)

  • Index Cond: ((org_id = 4,796) AND (entity_attribute_id = 183,108) AND (company_id = lists_entries.company_id))
  • Filter: ((value_location).country = 'United States'::text)
  • Rows Removed by Filter: 1
7. 5.874 5.874 ↓ 0.0 0 1,958

Index Scan using entity_values_org_id_list_entry_id_index on entity_values entity_values_1 (cost=0.56..8.59 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1,958)

  • Index Cond: ((org_id = 4,796) AND (list_entry_id = lists_entries.id))
  • Filter: ((entity_attribute_id = 230,984) AND (value_dropdown_option_id = 267,417))
  • Rows Removed by Filter: 2