Magento Check unprocessed changelog counts

sql-snippets

SELECT version_id - (SELECT version_id FROM enterprise_mview_metadata WHERE changelog_name = 'enterprise_url_rewrite_redirect_cl') FROM enterprise_url_rewrite_redirect_cl ORDER BY version_id DESC LIMIT 1;
SELECT version_id - (SELECT version_id FROM enterprise_mview_metadata WHERE changelog_name = 'cataloginventory_stock_status_cl') FROM cataloginventory_stock_status_cl ORDER BY version_id DESC LIMIT 1;
SELECT version_id - (SELECT version_id FROM enterprise_mview_metadata WHERE changelog_name = 'enterprise_url_rewrite_category_cl') FROM enterprise_url_rewrite_category_cl ORDER BY version_id DESC LIMIT 1;
SELECT version_id - (SELECT version_id FROM enterprise_mview_metadata WHERE changelog_name = 'enterprise_url_rewrite_product_cl') FROM enterprise_url_rewrite_product_cl ORDER BY version_id DESC LIMIT 1;
SELECT version_id - (SELECT version_id FROM enterprise_mview_metadata WHERE changelog_name = 'catalog_category_product_index_cl') FROM catalog_category_product_index_cl ORDER BY version_id DESC LIMIT 1;
SELECT version_id - (SELECT version_id FROM enterprise_mview_metadata WHERE changelog_name = 'catalog_category_product_cat_cl') FROM catalog_category_product_cat_cl ORDER BY version_id DESC LIMIT 1;
SELECT version_id - (SELECT version_id FROM enterprise_mview_metadata WHERE changelog_name = 'catalog_product_index_price_cl') FROM catalog_product_index_price_cl ORDER BY version_id DESC LIMIT 1;
SELECT version_id - (SELECT version_id FROM enterprise_mview_metadata WHERE changelog_name = 'catalog_category_flat_cl') FROM catalog_category_flat_cl ORDER BY version_id DESC LIMIT 1;
SELECT version_id - (SELECT version_id FROM enterprise_mview_metadata WHERE changelog_name = 'catalog_product_flat_cl') FROM catalog_product_flat_cl ORDER BY version_id DESC LIMIT 1;
SELECT version_id - (SELECT version_id FROM enterprise_mview_metadata WHERE changelog_name = 'catalogsearch_fulltext_cl') FROM catalogsearch_fulltext_cl ORDER BY version_id DESC LIMIT 1;