SHARE
TWEET

Untitled

a guest Jul 23rd, 2019 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2. meta_key,
  3. COUNT(*) AS `Rows`,
  4. ROUND(
  5. SUM(
  6. LENGTH(
  7. CONCAT(meta_id, post_id, meta_key, meta_value)
  8. )
  9. )/1048567, 2
  10. ) AS `Size_in_MB`
  11. FROM wp_postmeta
  12. GROUP BY meta_key
  13. ORDER BY `Size_in_MB` DESC;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top