Experiencing Slow Image Queries with WP Offload Media Lite

Hello WP Offload Media Support Team,
We’re currently experiencing performance issues related to slow database queries for images.

Diagnostic Info:

site_url(): https://wpscan.softwaresuggest.com/blog
home_url(): https://wpscan.softwaresuggest.com/blog
Database Name: wpscanssblog
Table Prefix: wp_
WordPress: 6.7.2
Web Server: nginx/1.18.0
PHP: 8.2.27
MySQL: 8.0.41
ext/mysqli: yes
PHP Memory Limit: 1024M
WP Memory Limit: 40M
Memory Usage: 153 MB
Blocked External HTTP Requests: None
WP Locale: en_US
Organize offloads by month/year: Enabled
WP_DEBUG: No
WP_DEBUG_LOG: No
WP_DEBUG_DISPLAY: Yes
SCRIPT_DEBUG: No
WP Max Upload Size: 128 MB
PHP Time Limit: 300
PHP Error Log:
WP Cron: Enabled
fsockopen: Enabled
allow_url_fopen: Enabled
OpenSSL: OpenSSL 3.0.2 15 Mar 2022
cURL: 7.81.0
Zlib Compression: Enabled
PHP GD: 2.3.3
Imagick: Enabled
Basic Auth: Disabled
Proxy: Disabled

Total Media Items: 29,720
Total Offloaded Media Items: 12,454
Total Not Offloaded Media Items: 17,266

Media Library Items: 29,720
Offloaded Media Library Items: 12,454
Not Offloaded Media Library Items: 17,266

Number of Image Sizes: 16

Names and Dimensions of Image Sizes:
thumbnail (150x150)
medium (300x300)
large (1024x1024)
1536x1536 (1536x1536)
2048x2048 (2048x2048)
et-pb-post-main-image (400x250)
et-pb-post-main-image-fullwidth (1080x675)
et-pb-portfolio-image (400x284)
et-pb-portfolio-module-image (510x382)
et-pb-portfolio-image-single (1080x9999)
et-pb-gallery-module-image-portrait (400x516)
et-pb-post-main-image-fullwidth-large (2880x1800)
et-pb-image--responsive--desktop (1280x720)
et-pb-image--responsive--tablet (980x551)
et-pb-image--responsive--phone (480x270)

WP_CONTENT_DIR: /usr/share/nginx/html/wpscanss/blog/wp-content
WP_CONTENT_URL: https://wpscan.softwaresuggest.com/blog/wp-content
UPLOADS: Not defined
WP_PLUGIN_DIR: /usr/share/nginx/html/wpscanss/blog/wp-content/plugins
WP_PLUGIN_URL: https://wpscan.softwaresuggest.com/blog/wp-content/plugins

AS3CF_PROVIDER: Not defined
AS3CF_BUCKET: Not defined
AS3CF_REGION: Not defined
AS3CF_SETTINGS: Not defined

Local URL:
https://wpscan.softwaresuggest.com/blog/wp-content/uploads/2025/03/example.jpg
Offload URL:
https://softwareauggest-blogimages.s3.ca-central-1.amazonaws.com/blog/wp-content/uploads/2025/03/07131325/example.jpg

OME Metadata Version: 12

Custom tables:
wp_as3cf_items: Ok

Storage Provider: Amazon S3
Use Server Roles: Off
Key File Path: N/A
Access Keys Set: No
Access Key ID Define: Not defined
Secret Access Key Define: Not defined

Bucket: softwareauggest-blogimages
Region: ca-central-1

Offload Media: On
Remove Local Media: Off
Enable Add Prefix to Bucket Path: On
Custom Prefix for Bucket Path: blog/wp-content/uploads/
Add Year & Month to Bucket Path: On
Add Object Version to Bucket Path: On

Delivery Provider: Amazon CloudFront
Deliver Offloaded Media: On
Use Custom Domain Name (CNAME): Off
Custom Domain (CNAME): (none)

Force HTTPS: Off

Active Theme Name: Divi
Active Theme Version: 4.27.4
Active Theme Folder: Divi

Active Plugins:
410 for WordPress (v0.8.7) by Samir Shah
Advanced Custom Fields (v6.3.12) by WP Engine
Advanced Database Cleaner (v3.1.5) by Younes JFR.
All-in-One WP Migration (v7.89) by ServMask
All-in-One WP Migration Unlimited Extension (v2.65) by ServMask
Attachment Pages Redirect (v1.1.2) by Samuel Aguilera
Autoptimize (v3.1.13) by Frank Goossens (futtta)
Better Search Replace (v1.4.10) by WP Engine
Broken Link Checker (v2.4.2) by WPMU DEV
Captcha by BestWebSoft (v5.2.4) by BestWebSoft
Classic Editor (v1.6.7) by WordPress Contributors
Code Snippets (v3.6.7) by Code Snippets Pro
Content Views (v4.0.2) by Content Views
Content Views Pro (v5.10) by Content Views
Custom Post Templates (v1.5) by Simon Wheatley
Database Manager - WP Adminer (v3.1.1) by Pexle Chris
Divi Blog Extras (v2.6.5) by Elicus
Duplicate Page (v4.5.4) by mndpsingh287
Export All URLs (v4.7.1) by Atlas Gondal
Header and Footer Scripts (v2.2.2) by Anand Kumar
Insert HTML Snippet (v1.3.8) by xyzscripts.com
LuckyWP Table of Contents (v2.1.10) by LuckyWP
Monarch Plugin (v1.4.14) by Elegant Themes
Newsletter, SMTP, Email marketing and Subscribe forms by Brevo (v3.1.92) by Brevo
One User Avatar (v2.5.0) by One Designs
Query Monitor (v3.17.2) by John Blackbourn
Reading Progress Bar (v1.3) by Jb Audras
Reading Time WP (v2.0.17) by Jason Yingling
Redirection (v5.5.1) by John Godley
Redis Object Cache (v2.5.4) by Till Krüss
Schema & Structured Data for WP & AMP (v1.40) by Magazine3
Simple Author Box (v2.54) by WebFactory Ltd
Super Page Cache (v5.0.9) by Themeisle
WP Activity Log (v5.2.2) by Melapress
WP External Links (v2.62) by WebFactory Ltd
WP File Manager (v8.0.1) by mndpsingh287
WP Offload Media Lite (v3.2.11) by Delicious Brains
WP Revisions Control (v1.4.3) by Erick Hitter
WP Sitemap Page (v1.9.4) by Tony Archambeau
WP-Optimize - Clean, Compress, Cache (v4.1.0) by TeamUpdraft, DavidAnderson
WPCode Lite (v2.2.5) by WPCode
XML Sitemap & Google News (v5.4.9) by RavanH
Yoast SEO (v24.4) by Team Yoast
Yoast Test Helper (v1.18) by Team Yoast
a3 Lazy Load (v2.7.3) by a3rev Software

Must-use Plugins:
pexlechris_adminer_avoid_conflicts_with_other_plugins.php (v3.0.3) by

Drop-ins:
db.php - Query Monitor Database Class (Drop-in)

• This topic was modified 2 weeks ago by savanappitdisimple.

The page I need help with: [log in to see the link]