Optimizar BD en phpmyadmin en siteground

 Paso 1: Ir al phpmyadmin a la BD

SELECT * FROM ela_posts

WHERE post_type = 'revision';

DELETE FROM ela_posts

WHERE post_type = 'revision';

Paso 2: 

limpia el postmeta huérfano, de cualquier plugin o metakey

select * FROM ela_postmeta

WHERE post_id NOT IN (SELECT ID FROM ela_posts);

DELETE FROM ela_postmeta

WHERE post_id NOT IN (SELECT ID FROM ela_posts);

Paso 3 (opcional): Optimizar

OPTIMIZE TABLE ela_postmeta;

OPTIMIZE TABLE ela_posts;