explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e3O8

Settings
# exclusive inclusive rows x rows loops node
1. 68.776 83.594 ↑ 1.0 85,287 1

Hash Join (cost=8.07..5,837.47 rows=85,287 width=905) (actual time=0.122..83.594 rows=85,287 loops=1)

  • Output: app_usage_day_summaries.id, app_usage_day_summaries.filter_date, app_usage_day_summaries.carrier_account_id, app_usage_day_summaries.network_name_id, app_usage_day_summaries.is_roaming, app_usage_day_summaries.device_id, app_usage_day_summaries.app_detail_parent_id, app_usage_day_summaries.app_detail_parent_name, app_usage_day_summaries.app_detail_parent_is_group, app_usage_day_summaries.app_detail_parent_label, app_usage_day_summaries.category_id, app_usage_day_summaries.app_id, app_usage_day_summaries.tariff_id, app_usage_day_summaries.sim_mnc_id, app_usage_day_summaries.category_name, app_usage_day_summaries.user_id, app_usage_day_summaries.user_name, app_usage_day_summaries.company_id, app_usage_day_summaries.device_name, app_usage_day_summaries.network_name_name, app_usage_day_summaries.tariff_country_id, app_usage_day_summaries.country_name, app_usage_day_summaries.carrier_account_phone_number, app_usage_day_summaries.carrier_account_name, app_usage_day_summaries.contract_start_date, app_usage_day_summaries.start_date, app_usage_day_summaries.end_date, app_usage_day_summaries.plan_id, app_usage_day_summaries.plan_name, app_usage_day_summaries.plan_rate_type, app_usage_day_summaries.plan_data_cost_in_cents_per_month, app_usage_day_summaries.plan_data_in_bytes_per_month, app_usage_day_summaries.plan_overage_data_mb_rate, app_usage_day_summaries.tariff_name, app_usage_day_summaries.tariff_roaming_data_mb_rate, app_usage_day_summaries.total_bytes, app_usage_day_summaries.network_type_code, app_usage_day_summaries.is_free, app_usage_day_summaries.mnc_id, app_usage_day_summaries.roaming_rule_id, 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
  • Hash Cond: ((app_usage_day_summaries.plan_id = tariffs.plan_id) AND (app_usage_day_summaries.tariff_country_id = tariffs.country_id))
  • Buffers: shared hit=3486
2. 14.732 14.732 ↑ 1.0 85,287 1

Seq Scan on public.mv_app_usage_day_summaries app_usage_day_summaries (cost=0.00..4,336.87 rows=85,287 width=316) (actual time=0.017..14.732 rows=85,287 loops=1)

  • Output: app_usage_day_summaries.id, app_usage_day_summaries.filter_date, app_usage_day_summaries.carrier_account_id, app_usage_day_summaries.network_name_id, app_usage_day_summaries.is_roaming, app_usage_day_summaries.device_id, app_usage_day_summaries.app_detail_parent_id, app_usage_day_summaries.app_detail_parent_name, app_usage_day_summaries.app_detail_parent_is_group, app_usage_day_summaries.app_detail_parent_label, app_usage_day_summaries.category_id, app_usage_day_summaries.app_id, app_usage_day_summaries.tariff_id, app_usage_day_summaries.sim_mnc_id, app_usage_day_summaries.category_name, app_usage_day_summaries.user_id, app_usage_day_summaries.user_name, app_usage_day_summaries.company_id, app_usage_day_summaries.device_name, app_usage_day_summaries.network_name_name, app_usage_day_summaries.tariff_country_id, app_usage_day_summaries.country_name, app_usage_day_summaries.carrier_account_phone_number, app_usage_day_summaries.carrier_account_name, app_usage_day_summaries.contract_start_date, app_usage_day_summaries.start_date, app_usage_day_summaries.end_date, app_usage_day_summaries.plan_id, app_usage_day_summaries.plan_name, app_usage_day_summaries.plan_rate_type, app_usage_day_summaries.plan_data_cost_in_cents_per_month, app_usage_day_summaries.plan_data_in_bytes_per_month, app_usage_day_summaries.plan_overage_data_mb_rate, app_usage_day_summaries.tariff_name, app_usage_day_summaries.tariff_roaming_data_mb_rate, app_usage_day_summaries.total_bytes, app_usage_day_summaries.network_type_code, app_usage_day_summaries.is_free, app_usage_day_summaries.mnc_id, app_usage_day_summaries.roaming_rule_id
  • Buffers: shared hit=3484
3. 0.053 0.086 ↑ 1.0 243 1

Hash (cost=4.43..4.43 rows=243 width=589) (actual time=0.086..0.086 rows=243 loops=1)

  • 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
  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
  • Buffers: shared hit=2
4. 0.033 0.033 ↑ 1.0 243 1

Seq Scan on public.tariffs (cost=0.00..4.43 rows=243 width=589) (actual time=0.007..0.033 rows=243 loops=1)

  • 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
  • Buffers: shared hit=2
Planning time : 0.254 ms