explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pbKY

Settings
# exclusive inclusive rows x rows loops node
1. 85.470 17,807.439 ↓ 17.2 206,452 1

Subquery Scan on app_usage_day_summaries_with_total_roaming_country_usage (cost=14,132.10..14,701.29 rows=11,983 width=172) (actual time=15,059.470..17,807.439 rows=206,452 loops=1)

  • Output: app_usage_day_summaries_with_total_roaming_country_usage.id, app_usage_day_summaries_with_total_roaming_country_usage.tariff_id, app_usage_day_summaries_with_total_roaming_country_usage.app_id, app_usage_day_summaries_with_total_roaming_country_usage.sim_mnc_id, app_usage_day_summaries_with_total_roaming_country_usage.tariff_country_id, app_usage_day_summaries_with_total_roaming_country_usage.network_name_id, app_usage_day_summaries_with_total_roaming_country_usage.network_type_code, app_usage_day_summaries_with_total_roaming_country_usage.filter_date, app_usage_day_summaries_with_total_roaming_country_usage.total_bytes, app_usage_day_summaries_with_total_roaming_country_usage.is_roaming, app_usage_day_summaries_with_total_roaming_country_usage.end_date, app_usage_day_summaries_with_total_roaming_country_usage.carrier_account_id, app_usage_day_summaries_with_total_roaming_country_usage.total_billing_usage, app_usage_day_summaries_with_total_roaming_country_usage.total_roaming_country_usage, app_usage_day_summaries_with_total_roaming_country_usage.roaming_days, app_usage_day_summaries_with_total_roaming_country_usage.roaming_details, app_usage_day_summaries_with_total_roaming_country_usage.is_free, app_usage_day_summaries_with_total_roaming_country_usage.total_really_usaged, app_usage_day_summaries_with_total_roaming_country_usage.category_id, app_usage_day_summaries_with_total_roaming_country_usage.label, app_usage_day_summaries_with_total_roaming_country_usage.app_detail_id
  • Buffers: shared hit=9042, temp read=8901 written=8931
2. 2,587.973 17,721.969 ↓ 17.2 206,452 1

WindowAgg (cost=14,132.10..14,581.46 rows=11,983 width=176) (actual time=15,059.467..17,721.969 rows=206,452 loops=1)

  • Output: app_usage_day_summaries.id, app_usage_day_summaries.tariff_id, app_usage_day_summaries.app_id, app_usage_day_summaries.sim_mnc_id, app_usage_day_summaries.tariff_country_id, app_usage_day_summaries.network_name_id, app_usage_day_summaries.network_type_code, app_usage_day_summaries.filter_date, app_usage_day_summaries.total_bytes, app_usage_day_summaries.is_roaming, app_usage_day_summaries.end_date, app_usage_day_summaries.carrier_account_id, (sum(CASE WHEN (app_usage_day_summaries.is_roaming OR app_usage_day_summaries.is_free) THEN '0'::double precision ELSE app_usage_day_summaries.total_bytes END) OVER (?)), sum(CASE WHEN app_usage_day_summaries.is_roaming THEN app_usage_day_summaries.total_bytes ELSE '0'::double precision END) OVER (?), json_build_array(json_build_object('filter_date', app_usage_day_summaries.filter_date, 'phone_calls_duration_in_seconds_incoming', roaming_days.phone_calls_duration_in_seconds_incoming, 'phone_calls_duration_in_seconds_outgoing', roaming_days.phone_calls_duration_in_seconds_outgoing, 'phone_calls_duration_in_minutes_incoming', roaming_days.phone_calls_duration_in_minutes_incoming, 'phone_calls_duration_in_minutes_outgoing', roaming_days.phone_calls_duration_in_minutes_outgoing, 'text_messages_size_incoming', roaming_days.text_messages_size_incoming, 'text_messages_size_outgoing', roaming_days.text_messages_size_outgoing, 'app_usages_total_bytes', roaming_days.app_usages_total_bytes)), json_build_array(json_build_object('filter_date', app_usage_day_summaries.filter_date, 'total_bytes', app_usage_day_summaries.total_bytes)), app_usage_day_summaries.is_free, (sum(CASE WHEN (app_usage_day_summaries.is_roaming OR app_usage_day_summaries.is_free) THEN '0'::double precision ELSE app_usage_day_summaries.total_bytes END) OVER (?)), app_usage_day_summaries.category_id, app_usage_day_summaries.app_detail_parent_label, app_usage_day_summaries.app_detail_parent_id, app_usage_day_summaries.start_date
  • Buffers: shared hit=9042, temp read=8901 written=8931
3. 422.824 15,133.996 ↓ 17.2 206,452 1

Sort (cost=14,132.10..14,162.05 rows=11,983 width=128) (actual time=15,059.140..15,133.996 rows=206,452 loops=1)

  • Output: app_usage_day_summaries.tariff_country_id, app_usage_day_summaries.is_roaming, app_usage_day_summaries.end_date, app_usage_day_summaries.carrier_account_id, app_usage_day_summaries.start_date, app_usage_day_summaries.id, app_usage_day_summaries.tariff_id, app_usage_day_summaries.app_id, app_usage_day_summaries.sim_mnc_id, app_usage_day_summaries.network_name_id, app_usage_day_summaries.network_type_code, app_usage_day_summaries.filter_date, app_usage_day_summaries.total_bytes, app_usage_day_summaries.is_free, roaming_days.phone_calls_duration_in_seconds_incoming, roaming_days.phone_calls_duration_in_seconds_outgoing, roaming_days.phone_calls_duration_in_minutes_incoming, roaming_days.phone_calls_duration_in_minutes_outgoing, roaming_days.text_messages_size_incoming, roaming_days.text_messages_size_outgoing, roaming_days.app_usages_total_bytes, app_usage_day_summaries.category_id, app_usage_day_summaries.app_detail_parent_label, app_usage_day_summaries.app_detail_parent_id, (sum(CASE WHEN (app_usage_day_summaries.is_roaming OR app_usage_day_summaries.is_free) THEN '0'::double precision ELSE app_usage_day_summaries.total_bytes END) OVER (?))
  • Sort Key: app_usage_day_summaries.carrier_account_id, app_usage_day_summaries.is_roaming, app_usage_day_summaries.tariff_country_id, app_usage_day_summaries.start_date, app_usage_day_summaries.end_date
  • Sort Method: external merge Disk: 32368kB
  • Buffers: shared hit=9042, temp read=8901 written=8931
4. 228.870 14,711.172 ↓ 17.2 206,452 1

WindowAgg (cost=13,020.75..13,320.33 rows=11,983 width=128) (actual time=14,287.863..14,711.172 rows=206,452 loops=1)

  • Output: app_usage_day_summaries.tariff_country_id, app_usage_day_summaries.is_roaming, app_usage_day_summaries.end_date, app_usage_day_summaries.carrier_account_id, app_usage_day_summaries.start_date, app_usage_day_summaries.id, app_usage_day_summaries.tariff_id, app_usage_day_summaries.app_id, app_usage_day_summaries.sim_mnc_id, app_usage_day_summaries.network_name_id, app_usage_day_summaries.network_type_code, app_usage_day_summaries.filter_date, app_usage_day_summaries.total_bytes, app_usage_day_summaries.is_free, roaming_days.phone_calls_duration_in_seconds_incoming, roaming_days.phone_calls_duration_in_seconds_outgoing, roaming_days.phone_calls_duration_in_minutes_incoming, roaming_days.phone_calls_duration_in_minutes_outgoing, roaming_days.text_messages_size_incoming, roaming_days.text_messages_size_outgoing, roaming_days.app_usages_total_bytes, app_usage_day_summaries.category_id, app_usage_day_summaries.app_detail_parent_label, app_usage_day_summaries.app_detail_parent_id, sum(CASE WHEN (app_usage_day_summaries.is_roaming OR app_usage_day_summaries.is_free) THEN '0'::double precision ELSE app_usage_day_summaries.total_bytes END) OVER (?)
  • Buffers: shared hit=9042, temp read=4307 written=4322
5. 565.319 14,482.302 ↓ 17.2 206,452 1

Sort (cost=13,020.75..13,050.71 rows=11,983 width=120) (actual time=14,287.649..14,482.302 rows=206,452 loops=1)

  • Output: app_usage_day_summaries.tariff_country_id, app_usage_day_summaries.is_roaming, app_usage_day_summaries.end_date, app_usage_day_summaries.carrier_account_id, app_usage_day_summaries.start_date, app_usage_day_summaries.id, app_usage_day_summaries.tariff_id, app_usage_day_summaries.app_id, app_usage_day_summaries.sim_mnc_id, app_usage_day_summaries.network_name_id, app_usage_day_summaries.network_type_code, app_usage_day_summaries.filter_date, app_usage_day_summaries.total_bytes, app_usage_day_summaries.is_free, roaming_days.phone_calls_duration_in_seconds_incoming, roaming_days.phone_calls_duration_in_seconds_outgoing, roaming_days.phone_calls_duration_in_minutes_incoming, roaming_days.phone_calls_duration_in_minutes_outgoing, roaming_days.text_messages_size_incoming, roaming_days.text_messages_size_outgoing, roaming_days.app_usages_total_bytes, app_usage_day_summaries.category_id, app_usage_day_summaries.app_detail_parent_label, app_usage_day_summaries.app_detail_parent_id
  • Sort Key: app_usage_day_summaries.carrier_account_id, app_usage_day_summaries.is_roaming, app_usage_day_summaries.start_date, app_usage_day_summaries.end_date
  • Sort Method: external merge Disk: 30368kB
  • Buffers: shared hit=9042, temp read=4307 written=4322
6. 7,722.229 13,916.983 ↓ 17.2 206,452 1

Hash Left Join (cost=1,720.76..12,208.98 rows=11,983 width=120) (actual time=22.937..13,916.983 rows=206,452 loops=1)

  • Output: app_usage_day_summaries.tariff_country_id, app_usage_day_summaries.is_roaming, app_usage_day_summaries.end_date, app_usage_day_summaries.carrier_account_id, app_usage_day_summaries.start_date, app_usage_day_summaries.id, app_usage_day_summaries.tariff_id, app_usage_day_summaries.app_id, app_usage_day_summaries.sim_mnc_id, app_usage_day_summaries.network_name_id, app_usage_day_summaries.network_type_code, app_usage_day_summaries.filter_date, app_usage_day_summaries.total_bytes, app_usage_day_summaries.is_free, roaming_days.phone_calls_duration_in_seconds_incoming, roaming_days.phone_calls_duration_in_seconds_outgoing, roaming_days.phone_calls_duration_in_minutes_incoming, roaming_days.phone_calls_duration_in_minutes_outgoing, roaming_days.text_messages_size_incoming, roaming_days.text_messages_size_outgoing, roaming_days.app_usages_total_bytes, app_usage_day_summaries.category_id, app_usage_day_summaries.app_detail_parent_label, app_usage_day_summaries.app_detail_parent_id
  • Inner Unique: true
  • Hash Cond: ((app_usage_day_summaries.carrier_account_id = roaming_days.carrier_account_id) AND (roaming_tariffs.country_id = roaming_days.country_id))
  • Join Filter: (roaming_days.filter_date = app_usage_day_summaries.filter_date)
  • Rows Removed by Join Filter: 51208214
  • Buffers: shared hit=9042
7. 6,081.985 6,180.452 ↓ 17.2 206,452 1

Hash Join (cost=1,221.26..11,646.57 rows=11,983 width=92) (actual time=8.387..6,180.452 rows=206,452 loops=1)

  • Output: app_usage_day_summaries.id, app_usage_day_summaries.tariff_id, app_usage_day_summaries.app_id, app_usage_day_summaries.sim_mnc_id, app_usage_day_summaries.tariff_country_id, app_usage_day_summaries.network_name_id, app_usage_day_summaries.network_type_code, app_usage_day_summaries.filter_date, app_usage_day_summaries.total_bytes, app_usage_day_summaries.is_roaming, app_usage_day_summaries.end_date, app_usage_day_summaries.carrier_account_id, app_usage_day_summaries.is_free, app_usage_day_summaries.category_id, app_usage_day_summaries.app_detail_parent_label, app_usage_day_summaries.app_detail_parent_id, app_usage_day_summaries.start_date, roaming_tariffs.country_id
  • Hash Cond: (carrier_accounts.plan_id = plans.id)
  • Join Filter: CASE WHEN (tariffs.roaming_rule_id IS NULL) THEN (roaming_tariffs.id = tariffs.id) ELSE (roaming_tariffs.roaming_rule_id = tariffs.roaming_rule_id) END
  • Rows Removed by Join Filter: 49961384
  • Buffers: shared hit=8906
8. 0.000 97.785 ↓ 87.2 206,452 1

Gather (cost=1,185.18..11,457.40 rows=2,367 width=104) (actual time=7.637..97.785 rows=206,452 loops=1)

  • Output: app_usage_day_summaries.id, app_usage_day_summaries.tariff_id, app_usage_day_summaries.app_id, app_usage_day_summaries.sim_mnc_id, app_usage_day_summaries.tariff_country_id, app_usage_day_summaries.network_name_id, app_usage_day_summaries.network_type_code, app_usage_day_summaries.filter_date, app_usage_day_summaries.total_bytes, app_usage_day_summaries.is_roaming, app_usage_day_summaries.end_date, app_usage_day_summaries.carrier_account_id, app_usage_day_summaries.is_free, app_usage_day_summaries.category_id, app_usage_day_summaries.app_detail_parent_label, app_usage_day_summaries.app_detail_parent_id, app_usage_day_summaries.start_date, carrier_accounts.plan_id, tariffs.plan_id, tariffs.roaming_rule_id, tariffs.id
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=8900
9. 35.884 167.602 ↓ 69.8 68,817 3

Hash Join (cost=185.18..10,220.70 rows=986 width=104) (actual time=5.416..167.602 rows=68,817 loops=3)

  • Output: app_usage_day_summaries.id, app_usage_day_summaries.tariff_id, app_usage_day_summaries.app_id, app_usage_day_summaries.sim_mnc_id, app_usage_day_summaries.tariff_country_id, app_usage_day_summaries.network_name_id, app_usage_day_summaries.network_type_code, app_usage_day_summaries.filter_date, app_usage_day_summaries.total_bytes, app_usage_day_summaries.is_roaming, app_usage_day_summaries.end_date, app_usage_day_summaries.carrier_account_id, app_usage_day_summaries.is_free, app_usage_day_summaries.category_id, app_usage_day_summaries.app_detail_parent_label, app_usage_day_summaries.app_detail_parent_id, app_usage_day_summaries.start_date, carrier_accounts.plan_id, tariffs.plan_id, tariffs.roaming_rule_id, tariffs.id
  • Inner Unique: true
  • Hash Cond: (app_usage_day_summaries.sim_mnc_id = au_sim_mncs.id)
  • Buffers: shared hit=8900
  • Worker 0: actual time=5.449..6.948 rows=453 loops=1
  • Buffers: shared hit=123
  • Worker 1: actual time=4.618..488.603 rows=205572 loops=1
  • Buffers: shared hit=8720
10. 77.323 129.772 ↓ 69.8 68,817 3

Hash Join (cost=127.71..10,160.63 rows=986 width=104) (actual time=3.072..129.772 rows=68,817 loops=3)

  • Output: app_usage_day_summaries.id, app_usage_day_summaries.tariff_id, app_usage_day_summaries.app_id, app_usage_day_summaries.sim_mnc_id, app_usage_day_summaries.tariff_country_id, app_usage_day_summaries.network_name_id, app_usage_day_summaries.network_type_code, app_usage_day_summaries.filter_date, app_usage_day_summaries.total_bytes, app_usage_day_summaries.is_roaming, app_usage_day_summaries.end_date, app_usage_day_summaries.carrier_account_id, app_usage_day_summaries.is_free, app_usage_day_summaries.category_id, app_usage_day_summaries.app_detail_parent_label, app_usage_day_summaries.app_detail_parent_id, app_usage_day_summaries.start_date, carrier_accounts.plan_id, tariffs.plan_id, tariffs.roaming_rule_id, tariffs.id
  • Hash Cond: ((app_usage_day_summaries.network_name_id = au_network_names.id) AND (app_usage_day_summaries.carrier_account_id = carrier_accounts.id))
  • Buffers: shared hit=8722
  • Worker 0: actual time=3.087..4.301 rows=453 loops=1
  • Buffers: shared hit=42
  • Worker 1: actual time=3.335..381.468 rows=205572 loops=1
  • Buffers: shared hit=8639
11. 49.489 49.489 ↓ 1.0 68,817 3

Parallel Seq Scan on public.mv_app_usage_day_summaries app_usage_day_summaries (cost=0.00..9,338.03 rows=68,503 width=88) (actual time=0.017..49.489 rows=68,817 loops=3)

  • 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, app_usage_day_summaries.roaming_days, app_usage_day_summaries.roaming_details
  • Buffers: shared hit=8653
  • Worker 0: actual time=0.030..0.616 rows=453 loops=1
  • Buffers: shared hit=19
  • Worker 1: actual time=0.016..147.647 rows=205572 loops=1
  • Buffers: shared hit=8616
12. 0.520 2.960 ↓ 1.6 900 3

Hash (cost=119.25..119.25 rows=564 width=24) (actual time=2.960..2.960 rows=900 loops=3)

  • Output: au_network_names.id, tariffs.plan_id, tariffs.roaming_rule_id, tariffs.id, carrier_accounts.id, carrier_accounts.plan_id
  • Buckets: 1024 Batches: 1 Memory Usage: 54kB
  • Buffers: shared hit=69
  • Worker 0: actual time=2.996..2.996 rows=900 loops=1
  • Buffers: shared hit=23
  • Worker 1: actual time=3.291..3.291 rows=900 loops=1
  • Buffers: shared hit=23
13. 0.494 2.440 ↓ 1.6 900 3

Hash Join (cost=50.85..119.25 rows=564 width=24) (actual time=1.301..2.440 rows=900 loops=3)

  • Output: au_network_names.id, tariffs.plan_id, tariffs.roaming_rule_id, tariffs.id, carrier_accounts.id, carrier_accounts.plan_id
  • Hash Cond: (tariffs.plan_id = carrier_accounts.plan_id)
  • Buffers: shared hit=69
  • Worker 0: actual time=1.301..2.460 rows=900 loops=1
  • Buffers: shared hit=23
  • Worker 1: actual time=1.577..2.759 rows=900 loops=1
  • Buffers: shared hit=23
14. 0.080 1.855 ↑ 4.5 90 3

Hash Join (cost=34.55..82.20 rows=403 width=16) (actual time=1.011..1.855 rows=90 loops=3)

  • Output: au_network_names.id, tariffs.plan_id, tariffs.roaming_rule_id, tariffs.id
  • Hash Cond: (au_mncs.country_id = tariffs.country_id)
  • Buffers: shared hit=66
  • Worker 0: actual time=1.138..1.992 rows=90 loops=1
  • Buffers: shared hit=22
  • Worker 1: actual time=0.973..1.849 rows=90 loops=1
  • Buffers: shared hit=22
15. 0.499 0.958 ↑ 4.7 30 3

Hash Join (cost=13.15..55.89 rows=140 width=8) (actual time=0.151..0.958 rows=30 loops=3)

  • Output: au_network_names.id, au_mncs.country_id
  • Hash Cond: (au_mncs.id = au_network_names.mnc_id)
  • Buffers: shared hit=51
  • Worker 0: actual time=0.181..1.001 rows=30 loops=1
  • Buffers: shared hit=17
  • Worker 1: actual time=0.163..1.006 rows=30 loops=1
  • Buffers: shared hit=17
16. 0.387 0.387 ↑ 1.0 1,843 3

Seq Scan on public.mncs au_mncs (cost=0.00..34.43 rows=1,843 width=8) (actual time=0.011..0.387 rows=1,843 loops=3)

  • Output: au_mncs.id, au_mncs.country_id, au_mncs.carrier_id, au_mncs.mcc, au_mncs.mnc, au_mncs.created_at, au_mncs.updated_at
  • Buffers: shared hit=48
  • Worker 0: actual time=0.011..0.389 rows=1843 loops=1
  • Buffers: shared hit=16
  • Worker 1: actual time=0.009..0.398 rows=1843 loops=1
  • Buffers: shared hit=16
17. 0.019 0.072 ↑ 4.7 30 3

Hash (cost=11.40..11.40 rows=140 width=8) (actual time=0.072..0.072 rows=30 loops=3)

  • Output: au_network_names.id, au_network_names.mnc_id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=3
  • Worker 0: actual time=0.097..0.098 rows=30 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.087..0.087 rows=30 loops=1
  • Buffers: shared hit=1
18. 0.053 0.053 ↑ 4.7 30 3

Seq Scan on public.network_names au_network_names (cost=0.00..11.40 rows=140 width=8) (actual time=0.044..0.053 rows=30 loops=3)

  • Output: au_network_names.id, au_network_names.mnc_id
  • Buffers: shared hit=3
  • Worker 0: actual time=0.065..0.076 rows=30 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.057..0.067 rows=30 loops=1
  • Buffers: shared hit=1
19. 0.388 0.817 ↑ 1.0 729 3

Hash (cost=12.29..12.29 rows=729 width=16) (actual time=0.817..0.817 rows=729 loops=3)

  • Output: tariffs.plan_id, tariffs.country_id, tariffs.roaming_rule_id, tariffs.id
  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
  • Buffers: shared hit=15
  • Worker 0: actual time=0.923..0.924 rows=729 loops=1
  • Buffers: shared hit=5
  • Worker 1: actual time=0.733..0.733 rows=729 loops=1
  • Buffers: shared hit=5
20. 0.429 0.429 ↑ 1.0 729 3

Seq Scan on public.tariffs (cost=0.00..12.29 rows=729 width=16) (actual time=0.049..0.429 rows=729 loops=3)

  • Output: tariffs.plan_id, tariffs.country_id, tariffs.roaming_rule_id, tariffs.id
  • Buffers: shared hit=15
  • Worker 0: actual time=0.080..0.512 rows=729 loops=1
  • Buffers: shared hit=5
  • Worker 1: actual time=0.051..0.393 rows=729 loops=1
  • Buffers: shared hit=5
21. 0.027 0.091 ↑ 9.3 30 3

Hash (cost=12.80..12.80 rows=280 width=8) (actual time=0.091..0.091 rows=30 loops=3)

  • Output: carrier_accounts.id, carrier_accounts.plan_id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=3
  • Worker 0: actual time=0.133..0.133 rows=30 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.063..0.063 rows=30 loops=1
  • Buffers: shared hit=1
22. 0.064 0.064 ↑ 9.3 30 3

Seq Scan on public.carrier_accounts (cost=0.00..12.80 rows=280 width=8) (actual time=0.055..0.064 rows=30 loops=3)

  • Output: carrier_accounts.id, carrier_accounts.plan_id
  • Buffers: shared hit=3
  • Worker 0: actual time=0.080..0.092 rows=30 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.044..0.049 rows=30 loops=1
  • Buffers: shared hit=1
23. 1.306 1.946 ↑ 1.0 1,843 3

Hash (cost=34.43..34.43 rows=1,843 width=4) (actual time=1.946..1.946 rows=1,843 loops=3)

  • Output: au_sim_mncs.id
  • Buckets: 2048 Batches: 1 Memory Usage: 81kB
  • Buffers: shared hit=48
  • Worker 0: actual time=1.570..1.570 rows=1843 loops=1
  • Buffers: shared hit=16
  • Worker 1: actual time=0.920..0.920 rows=1843 loops=1
  • Buffers: shared hit=16
24. 0.640 0.640 ↑ 1.0 1,843 3

Seq Scan on public.mncs au_sim_mncs (cost=0.00..34.43 rows=1,843 width=4) (actual time=0.060..0.640 rows=1,843 loops=3)

  • Output: au_sim_mncs.id
  • Buffers: shared hit=48
  • Worker 0: actual time=0.079..0.771 rows=1843 loops=1
  • Buffers: shared hit=16
  • Worker 1: actual time=0.078..0.485 rows=1843 loops=1
  • Buffers: shared hit=16
25. 0.188 0.682 ↑ 1.0 729 1

Hash (cost=26.97..26.97 rows=729 width=20) (actual time=0.682..0.682 rows=729 loops=1)

  • Output: plans.id, roaming_tariffs.plan_id, roaming_tariffs.id, roaming_tariffs.roaming_rule_id, roaming_tariffs.country_id
  • Buckets: 1024 Batches: 1 Memory Usage: 43kB
  • Buffers: shared hit=6
26. 0.317 0.494 ↑ 1.0 729 1

Hash Join (cost=12.70..26.97 rows=729 width=20) (actual time=0.061..0.494 rows=729 loops=1)

  • Output: plans.id, roaming_tariffs.plan_id, roaming_tariffs.id, roaming_tariffs.roaming_rule_id, roaming_tariffs.country_id
  • Inner Unique: true
  • Hash Cond: (roaming_tariffs.plan_id = plans.id)
  • Buffers: shared hit=6
27. 0.166 0.166 ↑ 1.0 729 1

Seq Scan on public.tariffs roaming_tariffs (cost=0.00..12.29 rows=729 width=16) (actual time=0.015..0.166 rows=729 loops=1)

  • Output: roaming_tariffs.id, roaming_tariffs.name, roaming_tariffs.voice_rate, roaming_tariffs.created_at, roaming_tariffs.updated_at, roaming_tariffs.bill_per_minute, roaming_tariffs.plan_id, roaming_tariffs.country_id, roaming_tariffs.text_message_rate, roaming_tariffs.roaming_voice_rate, roaming_tariffs.roaming_data_mb_rate, roaming_tariffs.roaming_text_message_rate, roaming_tariffs.roaming_rule_id
  • Buffers: shared hit=5
28. 0.003 0.011 ↑ 40.0 3 1

Hash (cost=11.20..11.20 rows=120 width=4) (actual time=0.011..0.011 rows=3 loops=1)

  • Output: plans.id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
29. 0.008 0.008 ↑ 40.0 3 1

Seq Scan on public.plans (cost=0.00..11.20 rows=120 width=4) (actual time=0.007..0.008 rows=3 loops=1)

  • Output: plans.id
  • Buffers: shared hit=1
30. 8.456 14.302 ↑ 1.0 14,540 1

Hash (cost=281.40..281.40 rows=14,540 width=44) (actual time=14.302..14.302 rows=14,540 loops=1)

  • Output: roaming_days.phone_calls_duration_in_seconds_incoming, roaming_days.phone_calls_duration_in_seconds_outgoing, roaming_days.phone_calls_duration_in_minutes_incoming, roaming_days.phone_calls_duration_in_minutes_outgoing, roaming_days.text_messages_size_incoming, roaming_days.text_messages_size_outgoing, roaming_days.app_usages_total_bytes, roaming_days.carrier_account_id, roaming_days.country_id, roaming_days.filter_date
  • Buckets: 16384 Batches: 1 Memory Usage: 1208kB
  • Buffers: shared hit=136
31. 5.846 5.846 ↑ 1.0 14,540 1

Seq Scan on public.roaming_days (cost=0.00..281.40 rows=14,540 width=44) (actual time=0.016..5.846 rows=14,540 loops=1)

  • Output: roaming_days.phone_calls_duration_in_seconds_incoming, roaming_days.phone_calls_duration_in_seconds_outgoing, roaming_days.phone_calls_duration_in_minutes_incoming, roaming_days.phone_calls_duration_in_minutes_outgoing, roaming_days.text_messages_size_incoming, roaming_days.text_messages_size_outgoing, roaming_days.app_usages_total_bytes, roaming_days.carrier_account_id, roaming_days.country_id, roaming_days.filter_date
  • Buffers: shared hit=136