explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6FJm

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 3.303 ↓ 0.0 0 1

GroupAggregate (cost=68.21..68.79 rows=1 width=2,840) (actual time=3.303..3.303 rows=0 loops=1)

  • Output: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_detail_parent.id, app_detail_parent.name, app_detail_parent.is_group, app_detail_parent.label, app_parent.category_id, app_parent.id, tariffs.id, app_usages.sim_mnc_id, categories.name, apps.user_id, users.name, users.company_id, devices.name, network_names.name, countries.id, countries.name, carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, plans.id, plans.name, plans.rate_type, plans.data_cost_in_cents_per_month, plans.data_in_bytes_per_month, plans.overage_data_mb_rate, tariffs.name, tariffs.roaming_data_mb_rate, (period_start(app_usages.filter_date, carrier_accounts.contract_start_date)), (period_end(app_usages.filter_date, carrier_accounts.contract_start_date)), (CASE WHEN (free_app_plans.id IS NULL) THEN false ELSE true END), sum(app_usages.total_bytes), network_names.mnc_id, tariffs.roaming_rule_id
  • Group Key: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_detail_parent.id, app_parent.id, tariffs.id, app_usages.sim_mnc_id, categories.name, apps.user_id, users.name, users.company_id, devices.name, network_names.name, countries.id, carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, plans.id, (CASE WHEN (free_app_plans.id IS NULL) THEN false ELSE true END), (period_start(app_usages.filter_date, carrier_accounts.contract_start_date)), (period_end(app_usages.filter_date, carrier_accounts.contract_start_date)), network_names.mnc_id
  • Buffers: shared hit=3 read=2
2. 0.143 3.301 ↓ 0.0 0 1

Sort (cost=68.21..68.22 rows=1 width=2,816) (actual time=3.301..3.301 rows=0 loops=1)

  • Output: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_detail_parent.id, app_parent.id, tariffs.id, app_usages.sim_mnc_id, categories.name, apps.user_id, users.name, users.company_id, devices.name, network_names.name, countries.id, carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, plans.id, (period_start(app_usages.filter_date, carrier_accounts.contract_start_date)), (period_end(app_usages.filter_date, carrier_accounts.contract_start_date)), (CASE WHEN (free_app_plans.id IS NULL) THEN false ELSE true END), network_names.mnc_id, app_detail_parent.name, app_detail_parent.is_group, app_detail_parent.label, app_parent.category_id, countries.name, plans.name, plans.rate_type, plans.data_cost_in_cents_per_month, plans.data_in_bytes_per_month, plans.overage_data_mb_rate, tariffs.name, tariffs.roaming_data_mb_rate, app_usages.total_bytes, tariffs.roaming_rule_id
  • Sort Key: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_detail_parent.id, app_parent.id, tariffs.id, app_usages.sim_mnc_id, categories.name, apps.user_id, users.name, users.company_id, devices.name, network_names.name, countries.id, carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, plans.id, (CASE WHEN (free_app_plans.id IS NULL) THEN false ELSE true END), (period_start(app_usages.filter_date, carrier_accounts.contract_start_date)), (period_end(app_usages.filter_date, carrier_accounts.contract_start_date)), network_names.mnc_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3 read=2
3. 0.000 3.158 ↓ 0.0 0 1

Nested Loop Left Join (cost=57.35..68.20 rows=1 width=2,816) (actual time=3.158..3.158 rows=0 loops=1)

  • Output: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_detail_parent.id, app_parent.id, tariffs.id, app_usages.sim_mnc_id, categories.name, apps.user_id, users.name, users.company_id, devices.name, network_names.name, countries.id, carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, plans.id, period_start(app_usages.filter_date, carrier_accounts.contract_start_date), period_end(app_usages.filter_date, carrier_accounts.contract_start_date), CASE WHEN (free_app_plans.id IS NULL) THEN false ELSE true END, network_names.mnc_id, app_detail_parent.name, app_detail_parent.is_group, app_detail_parent.label, app_parent.category_id, countries.name, plans.name, plans.rate_type, plans.data_cost_in_cents_per_month, plans.data_in_bytes_per_month, plans.overage_data_mb_rate, tariffs.name, tariffs.roaming_data_mb_rate, app_usages.total_bytes, tariffs.roaming_rule_id
  • Inner Unique: true
  • Buffers: shared hit=3 read=2
4. 0.001 3.158 ↓ 0.0 0 1

Nested Loop Left Join (cost=57.08..59.39 rows=1 width=2,287) (actual time=3.157..3.158 rows=0 loops=1)

  • Output: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_usages.sim_mnc_id, app_usages.total_bytes, app_usages.tariff_id, network_names.name, network_names.mnc_id, carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, apps.user_id, users.name, users.company_id, devices.name, app_detail_parent.id, app_detail_parent.name, app_detail_parent.is_group, app_detail_parent.label, app_parent.category_id, app_parent.id, categories.name, plans.id, plans.name, plans.rate_type, plans.data_cost_in_cents_per_month, plans.data_in_bytes_per_month, plans.overage_data_mb_rate, free_app_plans.id, countries.id, countries.name
  • Join Filter: (free_app_plans.plan_id = plans.id)
  • Buffers: shared hit=3 read=2
5. 0.001 3.157 ↓ 0.0 0 1

Nested Loop Left Join (cost=56.92..59.00 rows=1 width=2,283) (actual time=3.157..3.157 rows=0 loops=1)

  • Output: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_usages.sim_mnc_id, app_usages.total_bytes, app_usages.tariff_id, network_names.name, network_names.mnc_id, carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, apps.user_id, users.name, users.company_id, devices.name, app_details.id, app_detail_parent.id, app_detail_parent.name, app_detail_parent.is_group, app_detail_parent.label, app_parent.category_id, app_parent.id, categories.name, plans.id, plans.name, plans.rate_type, plans.data_cost_in_cents_per_month, plans.data_in_bytes_per_month, plans.overage_data_mb_rate, countries.id, countries.name
  • Inner Unique: true
  • Buffers: shared hit=3 read=2
6. 0.000 3.156 ↓ 0.0 0 1

Nested Loop (cost=56.78..58.67 rows=1 width=1,743) (actual time=3.156..3.156 rows=0 loops=1)

  • Output: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_usages.sim_mnc_id, app_usages.total_bytes, app_usages.tariff_id, network_names.name, network_names.mnc_id, carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, carrier_accounts.plan_id, apps.user_id, users.name, users.company_id, devices.name, app_details.id, app_detail_parent.id, app_detail_parent.name, app_detail_parent.is_group, app_detail_parent.label, app_parent.category_id, app_parent.id, categories.name, countries.id, countries.name
  • Inner Unique: true
  • Buffers: shared hit=3 read=2
7. 0.001 3.156 ↓ 0.0 0 1

Nested Loop (cost=56.64..58.46 rows=1 width=1,227) (actual time=3.155..3.156 rows=0 loops=1)

  • Output: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_usages.sim_mnc_id, app_usages.total_bytes, app_usages.tariff_id, network_names.name, network_names.mnc_id, carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, carrier_accounts.plan_id, apps.user_id, users.name, users.company_id, devices.name, app_details.id, app_detail_parent.id, app_detail_parent.name, app_detail_parent.is_group, app_detail_parent.label, app_parent.category_id, app_parent.id, countries.id, countries.name
  • Inner Unique: true
  • Buffers: shared hit=3 read=2
8. 0.019 3.155 ↓ 0.0 0 1

Merge Right Join (cost=56.36..58.11 rows=1 width=1,227) (actual time=3.155..3.155 rows=0 loops=1)

  • Output: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_usages.sim_mnc_id, app_usages.total_bytes, app_usages.tariff_id, network_names.name, network_names.mnc_id, carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, carrier_accounts.plan_id, apps.user_id, users.name, users.company_id, users.id, devices.name, app_details.id, app_details.parent_id, app_detail_parent.id, app_detail_parent.name, app_detail_parent.is_group, app_detail_parent.label, countries.id, countries.name
  • Merge Cond: (countries.id = app_usages.tariff_country_id)
  • Buffers: shared hit=3 read=2
9. 2.968 2.968 ↑ 229.0 1 1

Index Scan using countries_pkey on public.countries (cost=0.14..17.58 rows=229 width=14) (actual time=2.968..2.968 rows=1 loops=1)

  • Output: countries.id, countries.name, countries.created_at, countries.updated_at, countries.region_id, countries.iso, countries.exit_code, countries.trunk_code
  • Buffers: shared read=2
10. 0.116 0.168 ↓ 0.0 0 1

Sort (cost=54.96..54.96 rows=1 width=1,217) (actual time=0.168..0.168 rows=0 loops=1)

  • Output: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_usages.sim_mnc_id, app_usages.total_bytes, app_usages.tariff_country_id, app_usages.tariff_id, network_names.name, network_names.mnc_id, carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, carrier_accounts.plan_id, apps.user_id, users.name, users.company_id, users.id, devices.name, app_details.id, app_details.parent_id, app_detail_parent.id, app_detail_parent.name, app_detail_parent.is_group, app_detail_parent.label
  • Sort Key: app_usages.tariff_country_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3
11. 0.001 0.052 ↓ 0.0 0 1

Nested Loop (cost=6.60..54.95 rows=1 width=1,217) (actual time=0.052..0.052 rows=0 loops=1)

  • Output: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_usages.sim_mnc_id, app_usages.total_bytes, app_usages.tariff_country_id, app_usages.tariff_id, network_names.name, network_names.mnc_id, carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, carrier_accounts.plan_id, apps.user_id, users.name, users.company_id, users.id, devices.name, app_details.id, app_details.parent_id, app_detail_parent.id, app_detail_parent.name, app_detail_parent.is_group, app_detail_parent.label
  • Inner Unique: true
  • Buffers: shared hit=3
12. 0.001 0.051 ↓ 0.0 0 1

Nested Loop (cost=4.22..48.55 rows=1 width=1,176) (actual time=0.051..0.051 rows=0 loops=1)

  • Output: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_usages.sim_mnc_id, app_usages.total_bytes, app_usages.tariff_country_id, app_usages.tariff_id, network_names.name, network_names.mnc_id, carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, carrier_accounts.plan_id, apps.user_id, users.name, users.company_id, users.id, devices.name, app_details.id, app_details.parent_id
  • Inner Unique: true
  • Buffers: shared hit=3
13. 0.000 0.050 ↓ 0.0 0 1

Nested Loop (cost=1.25..41.57 rows=1 width=1,172) (actual time=0.050..0.050 rows=0 loops=1)

  • Output: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_usages.sim_mnc_id, app_usages.total_bytes, app_usages.tariff_country_id, app_usages.tariff_id, network_names.name, network_names.mnc_id, carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, carrier_accounts.plan_id, apps.user_id, apps.app_detail_id, users.name, users.company_id, users.id, devices.name
  • Inner Unique: true
  • Join Filter: (app_usages.device_id = devices.id)
  • Buffers: shared hit=3
14. 0.001 0.050 ↓ 0.0 0 1

Nested Loop (cost=1.12..33.41 rows=1 width=656) (actual time=0.050..0.050 rows=0 loops=1)

  • Output: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_usages.sim_mnc_id, app_usages.total_bytes, app_usages.tariff_country_id, app_usages.tariff_id, network_names.name, network_names.mnc_id, carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, carrier_accounts.plan_id, apps.user_id, apps.app_detail_id, users.name, users.company_id, users.id
  • Inner Unique: true
  • Buffers: shared hit=3
15. 0.000 0.049 ↓ 0.0 0 1

Nested Loop (cost=0.99..33.25 rows=1 width=637) (actual time=0.049..0.049 rows=0 loops=1)

  • Output: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_usages.sim_mnc_id, app_usages.total_bytes, app_usages.tariff_country_id, app_usages.tariff_id, network_names.name, network_names.mnc_id, carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, carrier_accounts.plan_id, apps.user_id, apps.app_detail_id
  • Inner Unique: true
  • Buffers: shared hit=3
16. 0.001 0.049 ↓ 0.0 0 1

Nested Loop (cost=0.71..24.94 rows=1 width=633) (actual time=0.048..0.049 rows=0 loops=1)

  • Output: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_usages.sim_mnc_id, app_usages.total_bytes, app_usages.app_id, app_usages.tariff_country_id, app_usages.tariff_id, network_names.name, network_names.mnc_id, carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, carrier_accounts.plan_id
  • Inner Unique: true
  • Buffers: shared hit=3
17. 0.001 0.048 ↓ 0.0 0 1

Nested Loop (cost=0.56..16.72 rows=1 width=561) (actual time=0.048..0.048 rows=0 loops=1)

  • Output: app_usages.filter_date, app_usages.carrier_account_id, app_usages.network_name_id, app_usages.is_roaming, app_usages.device_id, app_usages.sim_mnc_id, app_usages.total_bytes, app_usages.app_id, app_usages.tariff_country_id, app_usages.tariff_id, network_names.name, network_names.mnc_id
  • Inner Unique: true
  • Buffers: shared hit=3
18. 0.047 0.047 ↓ 0.0 0 1

Index Scan using idx_app_usages_by_summaries on public.app_usages (cost=0.42..8.44 rows=1 width=41) (actual time=0.047..0.047 rows=0 loops=1)

  • Output: app_usages.id, app_usages.app_id, app_usages.network_id, app_usages.rx_delta, app_usages.tx_delta, app_usages."timestamp", app_usages.updated_at, app_usages.device_id, app_usages.network_name_id, app_usages.roaming, app_usages.rx_delta_roaming, app_usages.tx_delta_roaming, app_usages.pid, app_usages.uid, app_usages.mobile_rx_bytes, app_usages.mobile_tx_bytes, app_usages.last_mobile_rx_bytes, app_usages.last_mobile_tx_bytes, app_usages.total_rx_bytes, app_usages.total_tx_bytes, app_usages.last_total_rx_bytes, app_usages.last_total_tx_bytes, app_usages.uid_rx_bytes, app_usages.uid_tx_bytes, app_usages.last_uid_rx_bytes, app_usages.last_uid_tx_bytes, app_usages.reported_by_pid, app_usages.total_bytes, app_usages.sim_mnc_id, app_usages.tariff_country_id, app_usages.tariff_id, app_usages.app_version, app_usages.comparison_mobile_rx_total, app_usages.comparison_mobile_tx_total, app_usages.comparison_wifi_rx_total, app_usages.comparison_wifi_tx_total, app_usages.mvi_mobile_rx_total, app_usages.mvi_mobile_tx_total, app_usages.mvi_wifi_rx_total, app_usages.mvi_wifi_tx_total, app_usages.comparison_rx_total, app_usages.comparison_tx_total, app_usages.filter_date, app_usages.network_type_code, app_usages.is_roaming, app_usages.carrier_account_id, app_usages.device_usage_id
  • Index Cond: ((app_usages.id >= 1) AND (app_usages.id <= 1000))
  • Buffers: shared hit=3
19. 0.000 0.000 ↓ 0.0 0

Index Scan using network_names_pkey on public.network_names (cost=0.14..8.16 rows=1 width=524) (never executed)

  • Output: network_names.id, network_names.user_id, network_names.name, network_names.created_at, network_names.updated_at, network_names.network_type_id, network_names.mnc_id
  • Index Cond: (network_names.id = app_usages.network_name_id)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using carrier_accounts_pkey on public.carrier_accounts (cost=0.15..8.17 rows=1 width=76) (never executed)

  • Output: carrier_accounts.id, carrier_accounts.user_id, carrier_accounts.device_id, carrier_accounts.plan_id, carrier_accounts.phone_number, carrier_accounts.sim_country, carrier_accounts.sim_carrier, carrier_accounts.sim_carrier_id, carrier_accounts.sim_serial_number, carrier_accounts.sim_state, carrier_accounts.carrier_id, carrier_accounts.contract_start_date, carrier_accounts.monitor, carrier_accounts.time_zone, carrier_accounts.last_report, carrier_accounts.name
  • Index Cond: (carrier_accounts.id = app_usages.carrier_account_id)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using apps_pkey on public.apps (cost=0.28..8.29 rows=1 width=12) (never executed)

  • Output: apps.id, apps.created_at, apps.updated_at, apps.user_id, apps.category_id, apps.app_detail_id, apps.system, apps.uid
  • Index Cond: (apps.id = app_usages.app_id)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using users_pkey on public.users (cost=0.14..0.16 rows=1 width=19) (never executed)

  • Output: users.id, users.company_id, users.name, users.created_at, users.updated_at, users.email, users.crypted_password, users.salt, users.remember_me_token, users.remember_me_token_expires_at, users.reset_password_token, users.reset_password_token_expires_at, users.reset_password_email_sent_at, users.last_device_id, users.role, users.last_login_at, users.last_logout_at, users.last_activity_at, users.last_login_from_ip_address, users.employee_number, users.phone_number, users.department, users.cost_center, users.contract_start_date, users.tos_agreed_at, users.email_downcase, users.channel_partner_id, users.invite_emailed_date, users.time_zone, users.last_carrier_account_id, users.onboard_status, users.type_of, users.locale
  • Index Cond: (users.id = apps.user_id)
23. 0.000 0.000 ↓ 0.0 0

Index Scan using devices_pkey on public.devices (cost=0.12..8.14 rows=1 width=520) (never executed)

  • Output: devices.id, devices.name, devices.device_id, devices.created_at, devices.updated_at, devices.user_id, devices.brand, devices.device, devices.display, devices.fingerprint, devices.hardware, devices.build_id, devices.model, devices.manufacturer, devices.product, devices.serial, devices.tags, devices.version, devices.version_codes, devices.hardware_id, devices.radio_version, devices.app_version, devices.last_report, devices.paused, devices.android_id, devices.last_ping, devices.desktop_version, devices.last_update_notification, devices.last_desktop_sync, devices.desktop_os_version
24. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on public.app_details (cost=2.97..6.98 rows=1 width=8) (never executed)

  • Output: app_details.id, app_details.url, app_details.image, app_details.created_at, app_details.updated_at, app_details.name, app_details.label, app_details.device_type, app_details.itunes_id, app_details.total_wifi_usage, app_details.total_mobile_usage, app_details.parent_id, app_details.is_group
  • Recheck Cond: (app_details.id = apps.app_detail_id)
25. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on app_details_pkey (cost=0.00..2.97 rows=1 width=0) (never executed)

  • Index Cond: (app_details.id = apps.app_detail_id)
26. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on public.app_details app_detail_parent (cost=2.37..6.39 rows=1 width=41) (never executed)

  • Output: app_detail_parent.id, app_detail_parent.url, app_detail_parent.image, app_detail_parent.created_at, app_detail_parent.updated_at, app_detail_parent.name, app_detail_parent.label, app_detail_parent.device_type, app_detail_parent.itunes_id, app_detail_parent.total_wifi_usage, app_detail_parent.total_mobile_usage, app_detail_parent.parent_id, app_detail_parent.is_group
  • Recheck Cond: (app_detail_parent.id = COALESCE(app_details.parent_id, app_details.id))
27. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on app_details_pkey (cost=0.00..2.37 rows=1 width=0) (never executed)

  • Index Cond: (app_detail_parent.id = COALESCE(app_details.parent_id, app_details.id))
28. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_app_app_user_id_detail_id on public.apps app_parent (cost=0.28..0.35 rows=1 width=16) (never executed)

  • Output: app_parent.id, app_parent.created_at, app_parent.updated_at, app_parent.user_id, app_parent.category_id, app_parent.app_detail_id, app_parent.system, app_parent.uid
  • Index Cond: ((app_parent.user_id = apps.user_id) AND (app_parent.app_detail_id = app_detail_parent.id))
29. 0.000 0.000 ↓ 0.0 0

Index Scan using categories_pkey on public.categories (cost=0.14..0.21 rows=1 width=520) (never executed)

  • Output: categories.id, categories.company_id, categories.name, categories.created_at, categories.updated_at
  • Index Cond: (categories.id = app_parent.category_id)
30. 0.000 0.000 ↓ 0.0 0

Index Scan using plans_pkey on public.plans (cost=0.14..0.33 rows=1 width=544) (never executed)

  • Output: plans.id, plans.name, plans.company_id, plans.created_at, plans.updated_at, plans.carrier_id, plans.rate_type, plans.voice_cost_in_cents_per_month, plans.data_cost_in_cents_per_month, plans.voice_in_minutes_per_month, plans.data_in_bytes_per_month, plans.disabled, plans.sales_tax_id, plans.text_cost_in_cents_per_month, plans.texts_per_month, plans.overage_voice_rate, plans.overage_text_message_rate, plans.overage_data_mb_rate, plans.user_id, plans.plan_template_id, plans.unlimited_inbound
  • Index Cond: (carrier_accounts.plan_id = plans.id)
31. 0.000 0.000 ↓ 0.0 0

Index Scan using index_free_app_plans_on_app_detail_id on public.free_app_plans (cost=0.15..0.30 rows=7 width=24) (never executed)

  • Output: free_app_plans.id, free_app_plans.plan_id, free_app_plans.app_detail_id, free_app_plans.created_at
  • Index Cond: (free_app_plans.app_detail_id = app_details.id)
32. 0.000 0.000 ↓ 0.0 0

Index Scan using tariffs_pkey on public.tariffs (cost=0.28..8.29 rows=1 width=532) (never executed)

  • Output: tariffs.id, tariffs.name, tariffs.voice_rate, tariffs.created_at, tariffs.updated_at, tariffs.bill_per_minute, tariffs.plan_id, tariffs.country_id, tariffs.text_message_rate, tariffs.roaming_voice_rate, tariffs.roaming_data_mb_rate, tariffs.roaming_text_message_rate, tariffs.roaming_rule_id
  • Index Cond: (tariffs.id = app_usages.tariff_id)