explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gNiN

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

GroupAggregate (cost=34,815.95..40,050.41 rows=9,064 width=2,840) (actual time=7,319.689..7,717.879 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=48367 read=6095, temp read=12376 written=12405
2. 1,149.974 7,415.995 ↓ 24.0 217,966 1

Sort (cost=34,815.95..34,838.61 rows=9,064 width=2,816) (actual time=7,319.658..7,415.995 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=48367 read=6095, temp read=12376 written=12405
3. 4,548.817 6,266.021 ↓ 24.0 217,966 1

Hash Left Join (cost=6,654.90..23,219.67 rows=9,064 width=2,816) (actual time=39.427..6,266.021 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=48367 read=6095
4. 133.539 1,716.544 ↓ 24.0 217,966 1

Hash Left Join (cost=6,633.50..18,642.34 rows=9,064 width=2,287) (actual time=38.407..1,716.544 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=48362 read=6095
5. 114.728 1,582.745 ↓ 24.0 217,966 1

Hash Left Join (cost=6,625.34..18,609.95 rows=9,064 width=2,277) (actual time=35.526..1,582.745 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=48359 read=6095
6. 133.558 1,468.012 ↓ 24.0 217,966 1

Hash Left Join (cost=6,581.34..15,438.56 rows=9,064 width=2,273) (actual time=35.491..1,468.012 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=48359 read=6095
7. 122.142 1,334.429 ↓ 24.0 217,966 1

Hash Join (cost=6,568.64..15,401.57 rows=9,064 width=1,733) (actual time=35.425..1,334.429 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=48358 read=6095
8. 141.902 1,212.256 ↓ 24.0 217,966 1

Hash Join (cost=6,555.49..15,363.90 rows=9,064 width=1,217) (actual time=35.371..1,212.256 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=48357 read=6095
9. 148.514 1,069.362 ↑ 1.0 217,966 1

Hash Join (cost=6,518.12..14,142.12 rows=225,582 width=1,217) (actual time=34.346..1,069.362 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=48347 read=6095
10. 141.776 890.141 ↑ 1.0 217,966 1

Hash Join (cost=164.64..7,195.22 rows=225,582 width=1,176) (actual time=3.610..890.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_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. 115.745 747.005 ↑ 1.0 217,966 1

Hash Join (cost=65.99..6,503.16 rows=225,582 width=1,172) (actual time=2.221..747.005 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. 119.841 631.233 ↑ 1.0 217,966 1

Hash Join (cost=64.63..5,752.79 rows=225,582 width=1,153) (actual time=2.152..631.233 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. 105.900 510.526 ↑ 1.0 221,760 1

Hash Join (cost=30.00..5,123.75 rows=225,582 width=1,149) (actual time=0.273..510.526 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. 105.779 404.560 ↑ 1.0 221,760 1

Hash Join (cost=13.70..4,506.33 rows=225,582 width=1,077) (actual time=0.175..404.560 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. 127.405 298.703 ↑ 1.0 221,760 1

Nested Loop (cost=0.54..3,883.11 rows=225,582 width=557) (actual time=0.073..298.703 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.058 0.058 ↓ 30.0 30 1

Index Scan using devices_pkey on public.devices (cost=0.12..8.14 rows=1 width=520) (actual time=0.028..0.058 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. 171.240 171.240 ↑ 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.014..5.708 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.056 0.078 ↑ 4.7 30 1

Hash (cost=11.40..11.40 rows=140 width=524) (actual time=0.078..0.078 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.040 0.066 ↑ 9.3 30 1

Hash (cost=12.80..12.80 rows=280 width=76) (actual time=0.066..0.066 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.026 0.026 ↑ 9.3 30 1

Seq Scan on public.carrier_accounts (cost=0.00..12.80 rows=280 width=76) (actual time=0.012..0.026 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.441 0.866 ↑ 1.0 1,095 1

Hash (cost=20.95..20.95 rows=1,095 width=12) (actual time=0.865..0.866 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.425 0.425 ↑ 1.0 1,095 1

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

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

Hash (cost=1.16..1.16 rows=16 width=19) (actual time=0.027..0.027 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.017 0.017 ↑ 1.0 16 1

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

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

Hash (cost=73.93..73.93 rows=1,977 width=8) (actual time=1.360..1.360 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.633 0.633 ↑ 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.054..0.633 rows=1,977 loops=1)

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

Hash (cost=6,328.77..6,328.77 rows=1,977 width=41) (actual time=30.707..30.707 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=214 read=6095
29. 29.665 29.665 ↑ 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.010..29.665 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=214 read=6095
30. 0.545 0.992 ↑ 1.0 1,095 1

Hash (cost=20.95..20.95 rows=1,095 width=16) (actual time=0.992..0.992 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.447 0.447 ↑ 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.013..0.447 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.007 0.031 ↑ 23.3 6 1

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

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

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

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

Hash (cost=11.20..11.20 rows=120 width=544) (actual time=0.025..0.025 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.011 0.011 ↑ 40.0 3 1

Seq Scan on public.plans (cost=0.00..11.20 rows=120 width=544) (actual time=0.009..0.011 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.001 0.005 ↓ 0.0 0 1

Hash (cost=23.60..23.60 rows=1,360 width=24) (actual time=0.005..0.005 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.004 0.004 ↓ 0.0 0 1

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

  • Output: free_app_plans.id, free_app_plans.app_detail_id, free_app_plans.plan_id
38. 0.147 0.260 ↓ 1.1 243 1

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

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

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

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

Hash (cost=12.29..12.29 rows=729 width=532) (actual time=0.660..0.660 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.318 0.318 ↑ 1.0 729 1

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

  • Output: tariffs.id, tariffs.name, tariffs.roaming_data_mb_rate, tariffs.roaming_rule_id
  • Buffers: shared hit=5