explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LdUI

Settings
# exclusive inclusive rows x rows loops node
1. 315.302 7,893.145 ↓ 22.8 206,452 1

GroupAggregate (cost=34,815.95..40,050.41 rows=9,064 width=2,840) (actual time=7,480.258..7,893.145 rows=206,452 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=48399 read=6063, temp read=12376 written=12405
2. 1,202.702 7,577.843 ↓ 24.0 217,966 1

Sort (cost=34,815.95..34,838.61 rows=9,064 width=2,816) (actual time=7,480.224..7,577.843 rows=217,966 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: external merge Disk: 62688kB
  • Buffers: shared hit=48399 read=6063, temp read=12376 written=12405
3. 4,620.603 6,375.141 ↓ 24.0 217,966 1

Hash Left Join (cost=6,654.90..23,219.67 rows=9,064 width=2,816) (actual time=49.039..6,375.141 rows=217,966 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
  • Hash Cond: (app_usages.tariff_id = tariffs.id)
  • Buffers: shared hit=48399 read=6063
4. 134.465 1,753.886 ↓ 24.0 217,966 1

Hash Left Join (cost=6,633.50..18,642.34 rows=9,064 width=2,287) (actual time=48.150..1,753.886 rows=217,966 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, devices.name, apps.user_id, users.name, users.company_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, free_app_plans.id, countries.id, countries.name
  • Inner Unique: true
  • Hash Cond: (app_usages.tariff_country_id = countries.id)
  • Buffers: shared hit=48394 read=6063
5. 115.643 1,619.213 ↓ 24.0 217,966 1

Hash Left Join (cost=6,625.34..18,609.95 rows=9,064 width=2,277) (actual time=47.906..1,619.213 rows=217,966 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, devices.name, apps.user_id, users.name, users.company_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, free_app_plans.id
  • Hash Cond: ((app_details.id = free_app_plans.app_detail_id) AND (plans.id = free_app_plans.plan_id))
  • Buffers: shared hit=48391 read=6063
6. 134.238 1,503.564 ↓ 24.0 217,966 1

Hash Left Join (cost=6,581.34..15,438.56 rows=9,064 width=2,273) (actual time=47.849..1,503.564 rows=217,966 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, devices.name, apps.user_id, users.name, users.company_id, 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
  • Inner Unique: true
  • Hash Cond: (carrier_accounts.plan_id = plans.id)
  • Buffers: shared hit=48391 read=6063
7. 123.450 1,369.292 ↓ 24.0 217,966 1

Hash Join (cost=6,568.64..15,401.57 rows=9,064 width=1,733) (actual time=47.749..1,369.292 rows=217,966 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, devices.name, apps.user_id, users.name, users.company_id, 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
  • Inner Unique: true
  • Hash Cond: (app_parent.category_id = categories.id)
  • Buffers: shared hit=48390 read=6063
8. 144.344 1,245.815 ↓ 24.0 217,966 1

Hash Join (cost=6,555.49..15,363.90 rows=9,064 width=1,217) (actual time=47.691..1,245.815 rows=217,966 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, devices.name, apps.user_id, users.name, users.company_id, 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
  • Inner Unique: true
  • Hash Cond: ((apps.user_id = app_parent.user_id) AND (app_detail_parent.id = app_parent.app_detail_id))
  • Buffers: shared hit=48389 read=6063
9. 154.117 1,100.500 ↑ 1.0 217,966 1

Hash Join (cost=6,518.12..14,142.12 rows=225,582 width=1,217) (actual time=46.624..1,100.500 rows=217,966 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, devices.name, apps.user_id, users.name, users.company_id, users.id, 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
  • Hash Cond: (COALESCE(app_details.parent_id, app_details.id) = app_detail_parent.id)
  • Buffers: shared hit=48379 read=6063
10. 146.008 903.941 ↑ 1.0 217,966 1

Hash Join (cost=164.64..7,195.22 rows=225,582 width=1,176) (actual time=4.161..903.941 rows=217,966 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, devices.name, apps.user_id, users.name, users.company_id, users.id, app_details.id, app_details.parent_id
  • Inner Unique: true
  • Hash Cond: (apps.app_detail_id = app_details.id)
  • Buffers: shared hit=48133
11. 113.095 756.220 ↑ 1.0 217,966 1

Hash Join (cost=65.99..6,503.16 rows=225,582 width=1,172) (actual time=2.386..756.220 rows=217,966 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, devices.name, apps.user_id, apps.app_detail_id, users.name, users.company_id, users.id
  • Inner Unique: true
  • Hash Cond: (apps.user_id = users.id)
  • Buffers: shared hit=48122
12. 121.914 643.097 ↑ 1.0 217,966 1

Hash Join (cost=64.63..5,752.79 rows=225,582 width=1,153) (actual time=2.297..643.097 rows=217,966 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, devices.name, apps.user_id, apps.app_detail_id
  • Inner Unique: true
  • Hash Cond: (app_usages.app_id = apps.id)
  • Buffers: shared hit=48121
13. 108.908 520.258 ↑ 1.0 221,760 1

Hash Join (cost=30.00..5,123.75 rows=225,582 width=1,149) (actual time=0.264..520.258 rows=221,760 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, devices.name
  • Inner Unique: true
  • Hash Cond: (app_usages.carrier_account_id = carrier_accounts.id)
  • Buffers: shared hit=48111
14. 109.459 411.280 ↑ 1.0 221,760 1

Hash Join (cost=13.70..4,506.33 rows=225,582 width=1,077) (actual time=0.167..411.280 rows=221,760 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, devices.name
  • Inner Unique: true
  • Hash Cond: (app_usages.network_name_id = network_names.id)
  • Buffers: shared hit=48110
15. 126.243 301.784 ↑ 1.0 221,760 1

Nested Loop (cost=0.54..3,883.11 rows=225,582 width=557) (actual time=0.076..301.784 rows=221,760 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, devices.name
  • Buffers: shared hit=48109
16. 0.041 0.041 ↓ 30.0 30 1

Index Scan using devices_pkey on public.devices (cost=0.12..8.14 rows=1 width=520) (actual time=0.009..0.041 rows=30 loops=1)

  • 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
  • Buffers: shared hit=3
17. 175.500 175.500 ↑ 1.0 7,392 30

Index Scan using index_app_usages_on_device_id on public.app_usages (cost=0.42..3,799.78 rows=7,519 width=41) (actual time=0.015..5.850 rows=7,392 loops=30)

  • 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.device_id = devices.id)
  • Filter: ((app_usages.id >= 1) AND (app_usages.id <= 742530))
  • Buffers: shared hit=48106
18. 0.015 0.037 ↑ 4.7 30 1

Hash (cost=11.40..11.40 rows=140 width=524) (actual time=0.037..0.037 rows=30 loops=1)

  • Output: network_names.name, network_names.mnc_id, network_names.id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
19. 0.022 0.022 ↑ 4.7 30 1

Seq Scan on public.network_names (cost=0.00..11.40 rows=140 width=524) (actual time=0.011..0.022 rows=30 loops=1)

  • Output: network_names.name, network_names.mnc_id, network_names.id
  • Buffers: shared hit=1
20. 0.018 0.070 ↑ 9.3 30 1

Hash (cost=12.80..12.80 rows=280 width=76) (actual time=0.070..0.070 rows=30 loops=1)

  • Output: carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, carrier_accounts.id, carrier_accounts.plan_id
  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=1
21. 0.052 0.052 ↑ 9.3 30 1

Seq Scan on public.carrier_accounts (cost=0.00..12.80 rows=280 width=76) (actual time=0.039..0.052 rows=30 loops=1)

  • Output: carrier_accounts.phone_number, carrier_accounts.name, carrier_accounts.contract_start_date, carrier_accounts.id, carrier_accounts.plan_id
  • Buffers: shared hit=1
22. 0.496 0.925 ↑ 1.0 1,095 1

Hash (cost=20.95..20.95 rows=1,095 width=12) (actual time=0.925..0.925 rows=1,095 loops=1)

  • Output: apps.user_id, apps.id, apps.app_detail_id
  • Buckets: 2048 Batches: 1 Memory Usage: 64kB
  • Buffers: shared hit=10
23. 0.429 0.429 ↑ 1.0 1,095 1

Seq Scan on public.apps (cost=0.00..20.95 rows=1,095 width=12) (actual time=0.012..0.429 rows=1,095 loops=1)

  • Output: apps.user_id, apps.id, apps.app_detail_id
  • Buffers: shared hit=10
24. 0.010 0.028 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=19) (actual time=0.028..0.028 rows=16 loops=1)

  • Output: users.name, users.company_id, users.id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
25. 0.018 0.018 ↑ 1.0 16 1

Seq Scan on public.users (cost=0.00..1.16 rows=16 width=19) (actual time=0.013..0.018 rows=16 loops=1)

  • Output: users.name, users.company_id, users.id
  • Buffers: shared hit=1
26. 0.916 1.713 ↑ 1.0 1,977 1

Hash (cost=73.93..73.93 rows=1,977 width=8) (actual time=1.713..1.713 rows=1,977 loops=1)

  • Output: app_details.id, app_details.parent_id
  • Buckets: 2048 Batches: 1 Memory Usage: 86kB
  • Buffers: shared hit=11
27. 0.797 0.797 ↑ 1.0 1,977 1

Index Only Scan using idx_app_detail_parent_id_id on public.app_details (cost=0.28..73.93 rows=1,977 width=8) (actual time=0.064..0.797 rows=1,977 loops=1)

  • Output: app_details.id, app_details.parent_id
  • Heap Fetches: 24
  • Buffers: shared hit=11
28. 1.003 42.442 ↑ 1.0 1,977 1

Hash (cost=6,328.77..6,328.77 rows=1,977 width=41) (actual time=42.442..42.442 rows=1,977 loops=1)

  • Output: app_detail_parent.id, app_detail_parent.name, app_detail_parent.is_group, app_detail_parent.label
  • Buckets: 2048 Batches: 1 Memory Usage: 159kB
  • Buffers: shared hit=246 read=6063
29. 41.439 41.439 ↑ 1.0 1,977 1

Seq Scan on public.app_details app_detail_parent (cost=0.00..6,328.77 rows=1,977 width=41) (actual time=0.019..41.439 rows=1,977 loops=1)

  • Output: app_detail_parent.id, app_detail_parent.name, app_detail_parent.is_group, app_detail_parent.label
  • Buffers: shared hit=246 read=6063
30. 0.547 0.971 ↑ 1.0 1,095 1

Hash (cost=20.95..20.95 rows=1,095 width=16) (actual time=0.971..0.971 rows=1,095 loops=1)

  • Output: app_parent.category_id, app_parent.id, app_parent.user_id, app_parent.app_detail_id
  • Buckets: 2048 Batches: 1 Memory Usage: 68kB
  • Buffers: shared hit=10
31. 0.424 0.424 ↑ 1.0 1,095 1

Seq Scan on public.apps app_parent (cost=0.00..20.95 rows=1,095 width=16) (actual time=0.014..0.424 rows=1,095 loops=1)

  • Output: app_parent.category_id, app_parent.id, app_parent.user_id, app_parent.app_detail_id
  • Buffers: shared hit=10
32. 0.006 0.027 ↑ 23.3 6 1

Hash (cost=11.40..11.40 rows=140 width=520) (actual time=0.027..0.027 rows=6 loops=1)

  • Output: categories.name, categories.id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
33. 0.021 0.021 ↑ 23.3 6 1

Seq Scan on public.categories (cost=0.00..11.40 rows=140 width=520) (actual time=0.018..0.021 rows=6 loops=1)

  • Output: categories.name, categories.id
  • Buffers: shared hit=1
34. 0.019 0.034 ↑ 40.0 3 1

Hash (cost=11.20..11.20 rows=120 width=544) (actual time=0.034..0.034 rows=3 loops=1)

  • Output: 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
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
35. 0.015 0.015 ↑ 40.0 3 1

Seq Scan on public.plans (cost=0.00..11.20 rows=120 width=544) (actual time=0.013..0.015 rows=3 loops=1)

  • Output: 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
  • Buffers: shared hit=1
36. 0.000 0.006 ↓ 0.0 0 1

Hash (cost=23.60..23.60 rows=1,360 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: free_app_plans.id, free_app_plans.app_detail_id, free_app_plans.plan_id
  • Buckets: 2048 Batches: 1 Memory Usage: 16kB
37. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on public.free_app_plans (cost=0.00..23.60 rows=1,360 width=24) (actual time=0.005..0.006 rows=0 loops=1)

  • Output: free_app_plans.id, free_app_plans.app_detail_id, free_app_plans.plan_id
38. 0.119 0.208 ↓ 1.1 243 1

Hash (cost=5.29..5.29 rows=229 width=14) (actual time=0.208..0.208 rows=243 loops=1)

  • Output: countries.id, countries.name
  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
  • Buffers: shared hit=3
39. 0.089 0.089 ↓ 1.1 243 1

Seq Scan on public.countries (cost=0.00..5.29 rows=229 width=14) (actual time=0.012..0.089 rows=243 loops=1)

  • Output: countries.id, countries.name
  • Buffers: shared hit=3
40. 0.335 0.652 ↑ 1.0 729 1

Hash (cost=12.29..12.29 rows=729 width=532) (actual time=0.652..0.652 rows=729 loops=1)

  • Output: tariffs.id, tariffs.name, tariffs.roaming_data_mb_rate, tariffs.roaming_rule_id
  • Buckets: 1024 Batches: 1 Memory Usage: 34kB
  • Buffers: shared hit=5
41. 0.317 0.317 ↑ 1.0 729 1

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

  • Output: tariffs.id, tariffs.name, tariffs.roaming_data_mb_rate, tariffs.roaming_rule_id
  • Buffers: shared hit=5
Planning time : 32.782 ms