explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 88dM

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 122,081.792 ↑ 1.0 1 1

Limit (cost=41.70..41.71 rows=1 width=8) (actual time=4,122,081.782..122,081.792 rows=1 loops=1)

2. 0.008 122,081.790 ↑ 1.0 1 1

Aggregate (cost=41.70..41.71 rows=1 width=8) (actual time=122,081.79..122,081.79 rows=1 loops=1)

3. 1.102 122,081.782 ↓ 33.0 33 1

Nested Loop Semi Join (cost=1.57..41.69 rows=1 width=44) (actual time=0.818..122,081.782 rows=33 loops=1)

4. 7.057 122,074.806 ↓ 1,958.0 1,958 1

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

5. 5.564 5.564 ↓ 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.015..5.564 rows=13,769 loops=1)

  • Index Cond: ((org_id = 4,796) AND (list_id = 26,657))
6. 122,062.185 122,062.185 ↓ 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.014..8.865 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
Planning time : 1.828 ms
Execution time : 47.184 ms