explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jn0c

Settings
# exclusive inclusive rows x rows loops node
1. 226.632 1,073.033 ↑ 1.0 47,751 1

Hash Left Join (cost=378.50..170,904.11 rows=47,751 width=2,978) (actual time=123.871..1,073.033 rows=47,751 loops=1)

  • Output: links.id, links.link, links.websites_id, replace((((links.link)::text || '.'::text) || (links_domains.host)::text), 'www.'::text, ''::text), (CASE WHEN ((links_domains.shost_internal)::text = (links_domains.host)::text) THEN replace((replace((links.link)::text, '.'::text, '-'::text) || '.'::text), 'www.'::text, ''::text) ELSE (replace(replace((((links.link)::text || '.'::text) || (links_domains.host)::text), 'www.'::text, ''::text), '.'::text, '-'::text) || '.'::text) END || (links_domains.shost_internal)::text), (CASE WHEN ((links_domains.shost_external)::text = (links_domains.host)::text) THEN replace((replace((links.link)::text, '.'::text, '-'::text) || '.'::text), 'www.'::text, ''::text) ELSE (replace(replace((((links.link)::text || '.'::text) || (links_domains.host)::text), 'www.'::text, ''::text), '.'::text, '-'::text) || '.'::text) END || (links_domains.shost_external)::text), links_domains.shost_wildcard, links.links_types_id, links.startfolder, links.homefolder_id, COALESCE(lng.id, 'en'::character varying), links.country_id, country.country, country.union_iso2letter, country.currency_code, links.header_image, CASE WHEN (links.template IS NULL) THEN websites.default_template ELSE links.template END, websites.default_template, websites.active, websites.external_flv_http_path, links.active, links_domains.active, CASE WHEN (links_domains.ip_external IS NULL) THEN websites.ip_external ELSE links_domains.ip_external END, websites.ip_internal, websites.host_internal, websites.host_external, links.links_domains_id, lower((websites.name)::text), links.links_partners_id, links_partners.links_partners_name, (COALESCE(links_partners.links_partners_legal_name, links_partners.links_partners_name))::character varying(500), links_domains.host, links_domains.shost_external, links_domains.id, links.business_owner_id, lp_bu.links_partners_name, (SubPlan 1), (SubPlan 2), links.lng_detect, links.fixed_ip_access, links.is_default, links.canonical_local_country_id, links.owner_id, wl_owner.username, sedit_apisoft.software_name, websites.global_ssl, websites.lng_param_required, websites.page_id_404, wl_owner.country, wl_owner_details.country_states_id
  • Inner Unique: true
  • Hash Cond: ((wl_owner.id = wl_owner_details.web_login_id) AND (websites.id = wl_owner_details.websites_id))
  • Buffers: shared hit=95579 read=1243
2. 26.571 404.011 ↑ 1.0 47,751 1

Hash Left Join (cost=324.48..3,829.00 rows=47,751 width=2,557) (actual time=102.561..404.011 rows=47,751 loops=1)

  • Output: websites.default_template, websites.active, websites.external_flv_http_path, websites.ip_external, websites.ip_internal, websites.host_internal, websites.host_external, websites.name, websites.id, websites.global_ssl, websites.lng_param_required, websites.page_id_404, links.id, links.link, links.websites_id, links.links_types_id, links.startfolder, links.homefolder_id, links.country_id, links.header_image, links.template, links.active, links.links_domains_id, links.links_partners_id, links.business_owner_id, links.custom_groups_ids, links.lng_detect, links.fixed_ip_access, links.is_default, links.canonical_local_country_id, links.owner_id, links_domains.host, links_domains.shost_internal, links_domains.shost_external, links_domains.shost_wildcard, links_domains.active, links_domains.ip_external, links_domains.id, country.country, country.union_iso2letter, country.currency_code, lng.id, links_partners.links_partners_name, links_partners.links_partners_legal_name, lp_bu.links_partners_name, sedit_apisoft.software_name, wl_owner.username, wl_owner.country, wl_owner.id
  • Inner Unique: true
  • Hash Cond: ((links.owner_id = wl_owner.id) AND (websites.id = wl_owner.websites_id))
  • Buffers: shared hit=76 read=1220
3. 20.940 351.420 ↑ 1.0 47,751 1

Hash Left Join (cost=226.73..3,480.56 rows=47,751 width=2,528) (actual time=76.529..351.420 rows=47,751 loops=1)

  • Output: websites.default_template, websites.active, websites.external_flv_http_path, websites.ip_external, websites.ip_internal, websites.host_internal, websites.host_external, websites.name, websites.id, websites.global_ssl, websites.lng_param_required, websites.page_id_404, links.id, links.link, links.websites_id, links.links_types_id, links.startfolder, links.homefolder_id, links.country_id, links.header_image, links.template, links.active, links.links_domains_id, links.links_partners_id, links.business_owner_id, links.custom_groups_ids, links.lng_detect, links.fixed_ip_access, links.is_default, links.canonical_local_country_id, links.owner_id, links_domains.host, links_domains.shost_internal, links_domains.shost_external, links_domains.shost_wildcard, links_domains.active, links_domains.ip_external, links_domains.id, country.country, country.union_iso2letter, country.currency_code, lng.id, links_partners.links_partners_name, links_partners.links_partners_legal_name, lp_bu.links_partners_name, sedit_apisoft.software_name
  • Inner Unique: true
  • Hash Cond: ((sedit_apilinks.web_login_api_types_id = sedit_apisoft.id) AND (websites.id = sedit_apisoft.websites_id))
  • Buffers: shared hit=74 read=1156
4. 26.578 329.814 ↑ 1.0 47,751 1

Hash Left Join (cost=225.43..3,226.35 rows=47,751 width=2,020) (actual time=75.850..329.814 rows=47,751 loops=1)

  • Output: websites.default_template, websites.active, websites.external_flv_http_path, websites.ip_external, websites.ip_internal, websites.host_internal, websites.host_external, websites.name, websites.id, websites.global_ssl, websites.lng_param_required, websites.page_id_404, links.id, links.link, links.websites_id, links.links_types_id, links.startfolder, links.homefolder_id, links.country_id, links.header_image, links.template, links.active, links.links_domains_id, links.links_partners_id, links.business_owner_id, links.custom_groups_ids, links.lng_detect, links.fixed_ip_access, links.is_default, links.canonical_local_country_id, links.owner_id, links_domains.host, links_domains.shost_internal, links_domains.shost_external, links_domains.shost_wildcard, links_domains.active, links_domains.ip_external, links_domains.id, country.country, country.union_iso2letter, country.currency_code, lng.id, links_partners.links_partners_name, links_partners.links_partners_legal_name, lp_bu.links_partners_name, sedit_apilinks.web_login_api_types_id
  • Hash Cond: ((links.id = sedit_apilinks.api_links_id) AND (websites.id = sedit_apilinks.websites_id))
  • Buffers: shared hit=74 read=1155
5. 25.409 298.985 ↑ 1.0 47,751 1

Hash Left Join (cost=224.30..2,867.08 rows=47,751 width=2,012) (actual time=71.589..298.985 rows=47,751 loops=1)

  • Output: websites.default_template, websites.active, websites.external_flv_http_path, websites.ip_external, websites.ip_internal, websites.host_internal, websites.host_external, websites.name, websites.id, websites.global_ssl, websites.lng_param_required, websites.page_id_404, links.id, links.link, links.websites_id, links.links_types_id, links.startfolder, links.homefolder_id, links.country_id, links.header_image, links.template, links.active, links.links_domains_id, links.links_partners_id, links.business_owner_id, links.custom_groups_ids, links.lng_detect, links.fixed_ip_access, links.is_default, links.canonical_local_country_id, links.owner_id, links_domains.host, links_domains.shost_internal, links_domains.shost_external, links_domains.shost_wildcard, links_domains.active, links_domains.ip_external, links_domains.id, country.country, country.union_iso2letter, country.currency_code, lng.id, links_partners.links_partners_name, links_partners.links_partners_legal_name, lp_bu.links_partners_name
  • Inner Unique: true
  • Hash Cond: (links.business_owner_id = lp_bu.id)
  • Buffers: shared hit=74 read=1154
6. 25.137 272.944 ↑ 1.0 47,751 1

Hash Left Join (cost=129.50..2,646.62 rows=47,751 width=1,997) (actual time=70.939..272.944 rows=47,751 loops=1)

  • Output: websites.default_template, websites.active, websites.external_flv_http_path, websites.ip_external, websites.ip_internal, websites.host_internal, websites.host_external, websites.name, websites.id, websites.global_ssl, websites.lng_param_required, websites.page_id_404, links.id, links.link, links.websites_id, links.links_types_id, links.startfolder, links.homefolder_id, links.country_id, links.header_image, links.template, links.active, links.links_domains_id, links.links_partners_id, links.business_owner_id, links.custom_groups_ids, links.lng_detect, links.fixed_ip_access, links.is_default, links.canonical_local_country_id, links.owner_id, links_domains.host, links_domains.shost_internal, links_domains.shost_external, links_domains.shost_wildcard, links_domains.active, links_domains.ip_external, links_domains.id, country.country, country.union_iso2letter, country.currency_code, lng.id, links_partners.links_partners_name, links_partners.links_partners_legal_name
  • Inner Unique: true
  • Hash Cond: (links.links_partners_id = links_partners.id)
  • Buffers: shared hit=17 read=1154
7. 31.684 228.170 ↑ 1.0 47,751 1

Hash Left Join (cost=34.70..2,426.16 rows=47,751 width=1,981) (actual time=51.290..228.170 rows=47,751 loops=1)

  • Output: websites.default_template, websites.active, websites.external_flv_http_path, websites.ip_external, websites.ip_internal, websites.host_internal, websites.host_external, websites.name, websites.id, websites.global_ssl, websites.lng_param_required, websites.page_id_404, links.id, links.link, links.websites_id, links.links_types_id, links.startfolder, links.homefolder_id, links.country_id, links.header_image, links.template, links.active, links.links_domains_id, links.links_partners_id, links.business_owner_id, links.custom_groups_ids, links.lng_detect, links.fixed_ip_access, links.is_default, links.canonical_local_country_id, links.owner_id, links_domains.host, links_domains.shost_internal, links_domains.shost_external, links_domains.shost_wildcard, links_domains.active, links_domains.ip_external, links_domains.id, country.country, country.union_iso2letter, country.currency_code, lng.id
  • Inner Unique: true
  • Hash Cond: (((links.languages_id)::text = (lng.id)::text) AND (websites.id = lng.websites_id))
  • Buffers: shared hit=15 read=1099
8. 28.831 196.344 ↑ 1.0 47,751 1

Hash Join (cost=30.29..2,166.34 rows=47,751 width=1,981) (actual time=51.133..196.344 rows=47,751 loops=1)

  • Output: websites.default_template, websites.active, websites.external_flv_http_path, websites.ip_external, websites.ip_internal, websites.host_internal, websites.host_external, websites.name, websites.id, websites.global_ssl, websites.lng_param_required, websites.page_id_404, links.id, links.link, links.websites_id, links.links_types_id, links.startfolder, links.homefolder_id, links.country_id, links.header_image, links.template, links.active, links.links_domains_id, links.links_partners_id, links.business_owner_id, links.custom_groups_ids, links.lng_detect, links.fixed_ip_access, links.is_default, links.canonical_local_country_id, links.owner_id, links.languages_id, links_domains.host, links_domains.shost_internal, links_domains.shost_external, links_domains.shost_wildcard, links_domains.active, links_domains.ip_external, links_domains.id, country.country, country.union_iso2letter, country.currency_code
  • Inner Unique: true
  • Hash Cond: (links.country_id = country.id)
  • Buffers: shared hit=13 read=1099
9. 26.985 135.677 ↑ 1.0 47,751 1

Hash Join (cost=15.62..2,024.22 rows=47,751 width=1,962) (actual time=19.283..135.677 rows=47,751 loops=1)

  • Output: websites.default_template, websites.active, websites.external_flv_http_path, websites.ip_external, websites.ip_internal, websites.host_internal, websites.host_external, websites.name, websites.id, websites.global_ssl, websites.lng_param_required, websites.page_id_404, links.id, links.link, links.websites_id, links.links_types_id, links.startfolder, links.homefolder_id, links.country_id, links.header_image, links.template, links.active, links.links_domains_id, links.links_partners_id, links.business_owner_id, links.custom_groups_ids, links.lng_detect, links.fixed_ip_access, links.is_default, links.canonical_local_country_id, links.owner_id, links.languages_id, links_domains.host, links_domains.shost_internal, links_domains.shost_external, links_domains.shost_wildcard, links_domains.active, links_domains.ip_external, links_domains.id
  • Inner Unique: true
  • Hash Cond: (links.links_domains_id = links_domains.id)
  • Buffers: shared hit=13 read=1090
10. 22.333 107.476 ↑ 1.0 47,751 1

Hash Join (cost=2.83..1,883.59 rows=47,751 width=1,886) (actual time=18.052..107.476 rows=47,751 loops=1)

  • Output: websites.default_template, websites.active, websites.external_flv_http_path, websites.ip_external, websites.ip_internal, websites.host_internal, websites.host_external, websites.name, websites.id, websites.global_ssl, websites.lng_param_required, websites.page_id_404, links.id, links.link, links.websites_id, links.links_types_id, links.startfolder, links.homefolder_id, links.country_id, links.header_image, links.template, links.active, links.links_domains_id, links.links_partners_id, links.business_owner_id, links.custom_groups_ids, links.lng_detect, links.fixed_ip_access, links.is_default, links.canonical_local_country_id, links.owner_id, links.languages_id
  • Inner Unique: true
  • Hash Cond: (links.links_types_id = links_types.id)
  • Buffers: shared hit=11 read=1084
11. 39.869 75.771 ↑ 1.0 47,751 1

Hash Join (cost=1.50..1,721.49 rows=47,751 width=1,886) (actual time=8.210..75.771 rows=47,751 loops=1)

  • Output: websites.default_template, websites.active, websites.external_flv_http_path, websites.ip_external, websites.ip_internal, websites.host_internal, websites.host_external, websites.name, websites.id, websites.global_ssl, websites.lng_param_required, websites.page_id_404, links.id, links.link, links.websites_id, links.links_types_id, links.startfolder, links.homefolder_id, links.country_id, links.header_image, links.template, links.active, links.links_domains_id, links.links_partners_id, links.business_owner_id, links.custom_groups_ids, links.lng_detect, links.fixed_ip_access, links.is_default, links.canonical_local_country_id, links.owner_id, links.languages_id
  • Inner Unique: true
  • Hash Cond: (links.websites_id = websites.id)
  • Buffers: shared hit=11 read=1083
12. 27.732 27.732 ↑ 1.0 47,751 1

Seq Scan on public.links (cost=0.00..1,570.51 rows=47,751 width=710) (actual time=0.009..27.732 rows=47,751 loops=1)

  • Output: links.id, links.link, links.links_types_id, links.startfolder, links.homefolder_id, links.languages_id, links.country_id, links.date_added, links.template, links.header_image, links.links_partners_id, links.websites_id, links.active, links.links_domains_id, links.admin_users_id, links.business_owner_id, links.custom_groups_ids, links.published, links.date_published, links.admin_history_dump, links.lng_detect, links.fixed_ip_access, links.is_default, links.canonical_local_country_id, links.owner_id
  • Buffers: shared hit=11 read=1082
13. 0.020 8.170 ↑ 1.0 22 1

Hash (cost=1.22..1.22 rows=22 width=1,176) (actual time=8.169..8.170 rows=22 loops=1)

  • Output: websites.default_template, websites.active, websites.external_flv_http_path, websites.ip_external, websites.ip_internal, websites.host_internal, websites.host_external, websites.name, websites.id, websites.global_ssl, websites.lng_param_required, websites.page_id_404
  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared read=1
14. 8.150 8.150 ↑ 1.0 22 1

Seq Scan on public.websites (cost=0.00..1.22 rows=22 width=1,176) (actual time=8.144..8.150 rows=22 loops=1)

  • Output: websites.default_template, websites.active, websites.external_flv_http_path, websites.ip_external, websites.ip_internal, websites.host_internal, websites.host_external, websites.name, websites.id, websites.global_ssl, websites.lng_param_required, websites.page_id_404
  • Buffers: shared read=1
15. 0.010 9.372 ↑ 1.0 15 1

Hash (cost=1.15..1.15 rows=15 width=8) (actual time=9.372..9.372 rows=15 loops=1)

  • Output: links_types.id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared read=1
16. 9.362 9.362 ↑ 1.0 15 1

Seq Scan on public.links_types (cost=0.00..1.15 rows=15 width=8) (actual time=9.359..9.362 rows=15 loops=1)

  • Output: links_types.id
  • Buffers: shared read=1
17. 0.067 1.216 ↑ 1.0 213 1

Hash (cost=10.13..10.13 rows=213 width=76) (actual time=1.216..1.216 rows=213 loops=1)

  • Output: links_domains.host, links_domains.shost_internal, links_domains.shost_external, links_domains.shost_wildcard, links_domains.active, links_domains.ip_external, links_domains.id
  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
  • Buffers: shared hit=2 read=6
18. 1.149 1.149 ↑ 1.0 213 1

Seq Scan on public.links_domains (cost=0.00..10.13 rows=213 width=76) (actual time=0.009..1.149 rows=213 loops=1)

  • Output: links_domains.host, links_domains.shost_internal, links_domains.shost_external, links_domains.shost_wildcard, links_domains.active, links_domains.ip_external, links_domains.id
  • Buffers: shared hit=2 read=6
19. 0.084 31.836 ↑ 1.0 252 1

Hash (cost=11.52..11.52 rows=252 width=27) (actual time=31.836..31.836 rows=252 loops=1)

  • Output: country.country, country.union_iso2letter, country.currency_code, country.id
  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
  • Buffers: shared read=9
20. 31.752 31.752 ↑ 1.0 252 1

Seq Scan on public.country (cost=0.00..11.52 rows=252 width=27) (actual time=12.508..31.752 rows=252 loops=1)

  • Output: country.country, country.union_iso2letter, country.currency_code, country.id
  • Buffers: shared read=9
21. 0.111 0.142 ↓ 1.0 68 1

Hash (cost=3.40..3.40 rows=67 width=11) (actual time=0.142..0.142 rows=68 loops=1)

  • Output: lng.id, lng.websites_id
  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=2
22. 0.031 0.031 ↓ 1.0 68 1

Seq Scan on public.languages lng (cost=0.00..3.40 rows=67 width=11) (actual time=0.008..0.031 rows=68 loops=1)

  • Output: lng.id, lng.websites_id
  • Filter: (lng.active > 0)
  • Rows Removed by Filter: 44
  • Buffers: shared hit=2
23. 0.379 19.637 ↑ 1.0 1,680 1

Hash (cost=73.80..73.80 rows=1,680 width=24) (actual time=19.637..19.637 rows=1,680 loops=1)

  • Output: links_partners.links_partners_name, links_partners.links_partners_legal_name, links_partners.id
  • Buckets: 2048 Batches: 1 Memory Usage: 114kB
  • Buffers: shared hit=2 read=55
24. 19.258 19.258 ↑ 1.0 1,680 1

Seq Scan on public.links_partners (cost=0.00..73.80 rows=1,680 width=24) (actual time=12.473..19.258 rows=1,680 loops=1)

  • Output: links_partners.links_partners_name, links_partners.links_partners_legal_name, links_partners.id
  • Buffers: shared hit=2 read=55
25. 0.325 0.632 ↑ 1.0 1,680 1

Hash (cost=73.80..73.80 rows=1,680 width=23) (actual time=0.632..0.632 rows=1,680 loops=1)

  • Output: lp_bu.links_partners_name, lp_bu.id
  • Buckets: 2048 Batches: 1 Memory Usage: 114kB
  • Buffers: shared hit=57
26. 0.307 0.307 ↑ 1.0 1,680 1

Seq Scan on public.links_partners lp_bu (cost=0.00..73.80 rows=1,680 width=23) (actual time=0.005..0.307 rows=1,680 loops=1)

  • Output: lp_bu.links_partners_name, lp_bu.id
  • Buffers: shared hit=57
27. 0.006 4.251 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=24) (actual time=4.251..4.251 rows=5 loops=1)

  • Output: sedit_apilinks.api_links_id, sedit_apilinks.websites_id, sedit_apilinks.web_login_api_types_id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared read=1
28. 4.245 4.245 ↑ 1.0 5 1

Seq Scan on public.web_login_api_apply sedit_apilinks (cost=0.00..1.05 rows=5 width=24) (actual time=4.243..4.245 rows=5 loops=1)

  • Output: sedit_apilinks.api_links_id, sedit_apilinks.websites_id, sedit_apilinks.web_login_api_types_id
  • Buffers: shared read=1
29. 0.007 0.666 ↑ 1.0 12 1

Hash (cost=1.12..1.12 rows=12 width=532) (actual time=0.666..0.666 rows=12 loops=1)

  • Output: sedit_apisoft.software_name, sedit_apisoft.id, sedit_apisoft.websites_id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared read=1
30. 0.659 0.659 ↑ 1.0 12 1

Seq Scan on public.web_login_api_types sedit_apisoft (cost=0.00..1.12 rows=12 width=532) (actual time=0.657..0.659 rows=12 loops=1)

  • Output: sedit_apisoft.software_name, sedit_apisoft.id, sedit_apisoft.websites_id
  • Buffers: shared read=1
31. 0.313 26.020 ↑ 1.0 1,253 1

Hash (cost=78.70..78.70 rows=1,270 width=37) (actual time=26.020..26.020 rows=1,253 loops=1)

  • Output: wl_owner.username, wl_owner.country, wl_owner.id, wl_owner.websites_id
  • Buckets: 2048 Batches: 1 Memory Usage: 105kB
  • Buffers: shared hit=2 read=64
32. 25.707 25.707 ↑ 1.0 1,253 1

Seq Scan on public.web_login wl_owner (cost=0.00..78.70 rows=1,270 width=37) (actual time=5.863..25.707 rows=1,253 loops=1)

  • Output: wl_owner.username, wl_owner.country, wl_owner.id, wl_owner.websites_id
  • Buffers: shared hit=2 read=64
33. 0.251 12.631 ↓ 1.0 1,203 1

Hash (cost=36.01..36.01 rows=1,201 width=24) (actual time=12.631..12.631 rows=1,203 loops=1)

  • Output: wl_owner_details.country_states_id, wl_owner_details.web_login_id, wl_owner_details.websites_id
  • Buckets: 2048 Batches: 1 Memory Usage: 73kB
  • Buffers: shared hit=2 read=22
34. 12.380 12.380 ↓ 1.0 1,203 1

Seq Scan on public.web_login_details wl_owner_details (cost=0.00..36.01 rows=1,201 width=24) (actual time=9.740..12.380 rows=1,203 loops=1)

  • Output: wl_owner_details.country_states_id, wl_owner_details.web_login_id, wl_owner_details.websites_id
  • Buffers: shared hit=2 read=22
35.          

SubPlan (forHash Left Join)

36. 47.751 238.755 ↑ 1.0 1 47,751

Aggregate (cost=1.71..1.72 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=47,751)

  • Output: array_agg(custom_groups.groups)
  • Buffers: shared hit=47750 read=1
37. 191.004 191.004 ↓ 0.0 0 47,751

Seq Scan on public.custom_groups (cost=0.00..1.70 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=47,751)

  • Output: custom_groups.id, custom_groups.groups, custom_groups.websites_id, custom_groups.published, custom_groups.group_type
  • Filter: ((custom_groups.websites_id = websites.id) AND (custom_groups.id = ANY (links.custom_groups_ids)))
  • Rows Removed by Filter: 28
  • Buffers: shared hit=47750 read=1
38. 47.751 191.004 ↑ 1.0 1 47,751

Aggregate (cost=1.71..1.72 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=47,751)

  • Output: array_agg(custom_groups_1.id)
  • Buffers: shared hit=47751
39. 143.253 143.253 ↓ 0.0 0 47,751

Seq Scan on public.custom_groups custom_groups_1 (cost=0.00..1.70 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=47,751)

  • Output: custom_groups_1.id, custom_groups_1.groups, custom_groups_1.websites_id, custom_groups_1.published, custom_groups_1.group_type
  • Filter: ((custom_groups_1.websites_id = websites.id) AND (custom_groups_1.id = ANY (links.custom_groups_ids)))
  • Rows Removed by Filter: 28
  • Buffers: shared hit=47751