wp_f12_prof_crawl_results

Column Definitions

CREATE TABLE Statement

CREATE TABLE wp_f12_prof_crawl_results ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, url varchar(2048) NOT NULL, device enum('desktop','mobile') NOT NULL DEFAULT 'desktop', ttfb float DEFAULT NULL, load_time float DEFAULT NULL, html_size int unsigned DEFAULT NULL, total_requests int unsigned DEFAULT NULL, css_count int unsigned DEFAULT NULL, css_size int unsigned DEFAULT NULL, js_count int unsigned DEFAULT NULL, js_size int unsigned DEFAULT NULL, image_count int unsigned DEFAULT NULL, image_size int unsigned DEFAULT NULL, external_requests int unsigned DEFAULT NULL, redirect_count int unsigned DEFAULT NULL, response_headers longtext DEFAULT NULL, assets_data longtext DEFAULT NULL, score float DEFAULT NULL, status enum('pending','crawling','done','error') NOT NULL DEFAULT 'pending', error_message text DEFAULT NULL, crawl_batch varchar(36) DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_url (url(191)), KEY idx_device (device), KEY idx_batch (crawl_batch), KEY idx_created (created_at) ) {$charset}; CREATE TABLE wp_f12_prof_recommendations ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, crawl_batch varchar(36) NOT NULL, priority enum('critical','high','medium','low','optional') NOT NULL DEFAULT 'medium', category varchar(50) NOT NULL, title varchar(500) NOT NULL, problem longtext NOT NULL, impact_score float DEFAULT NULL, impact_load_time varchar(50) DEFAULT NULL, impact_bandwidth varchar(50) DEFAULT NULL, affected_items longtext DEFAULT NULL, steps longtext DEFAULT NULL, tool_action varchar(100) DEFAULT NULL, manual_alternative longtext DEFAULT NULL, status enum('open','in_progress','done','ignored') NOT NULL DEFAULT 'open', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_batch (crawl_batch), KEY idx_priority (priority), KEY idx_category (category), KEY idx_status (status) ) {$charset}; CREATE TABLE wp_f12_prof_history ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, device enum('desktop','mobile') NOT NULL DEFAULT 'desktop', score_total float NOT NULL, score_server float DEFAULT NULL, score_loadtime float DEFAULT NULL, score_assets float DEFAULT NULL, score_images float DEFAULT NULL, score_cache float DEFAULT NULL, score_database float DEFAULT NULL, urls_crawled int unsigned DEFAULT NULL, issues_found int unsigned DEFAULT NULL, crawl_batch varchar(36) DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_device (device), KEY idx_created (created_at) ) {$charset}; CREATE TABLE wp_f12_prof_asset_rules ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, handle varchar(200) NOT NULL, asset_type enum('css','js') NOT NULL, action enum('disable','async','defer') NOT NULL DEFAULT 'disable', scope varchar(50) NOT NULL DEFAULT 'global', scope_value varchar(500) DEFAULT NULL, source_plugin varchar(200) DEFAULT NULL, is_protected tinyint(1) NOT NULL DEFAULT 0, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_handle (handle), KEY idx_type (asset_type), KEY idx_scope (scope) ) {$charset}; CREATE TABLE wp_f12_prof_pagespeed_results ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, url varchar(2048) NOT NULL, device enum('desktop','mobile') NOT NULL DEFAULT 'desktop', score_performance float DEFAULT NULL, score_accessibility float DEFAULT NULL, score_best_practices float DEFAULT NULL, score_seo float DEFAULT NULL, lcp_ms float DEFAULT NULL, fcp_ms float DEFAULT NULL, cls float DEFAULT NULL, tbt_ms float DEFAULT NULL, si_ms float DEFAULT NULL, tti_ms float DEFAULT NULL, field_lcp_ms int DEFAULT NULL, field_cls float DEFAULT NULL, field_inp_ms int DEFAULT NULL, field_fcp_ms int DEFAULT NULL, field_ttfb_ms int DEFAULT NULL, field_overall varchar(10) DEFAULT NULL, lighthouse_version varchar(20) DEFAULT NULL, runtime_error varchar(255) DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_url_device (url(191), device), KEY idx_created (created_at) ) {$charset}; CREATE TABLE wp_f12_prof_image_queue ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, attachment_id bigint(20) unsigned NOT NULL, original_path varchar(500) NOT NULL, original_size int unsigned NOT NULL DEFAULT 0, optimized_size int unsigned DEFAULT NULL, format_from varchar(10) NOT NULL DEFAULT '', format_to varchar(10) NOT NULL DEFAULT 'webp', quality int unsigned NOT NULL DEFAULT 80, status varchar(20) NOT NULL DEFAULT 'pending', error_message text DEFAULT NULL, batch_id varchar(36) DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_status (status), KEY idx_batch (batch_id) ) {$charset}; CREATE TABLE wp_f12_prof_asset_scan_results ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, url varchar(2048) NOT NULL, assets_json longtext NOT NULL, asset_count int unsigned DEFAULT 0, css_count int unsigned DEFAULT 0, js_count int unsigned DEFAULT 0, scan_batch varchar(36) DEFAULT NULL, scanned_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_url (url(191)), KEY idx_batch (scan_batch) ) {$charset}; CREATE TABLE wp_f12_prof_critical_css ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, template_key varchar(200) NOT NULL, template_label varchar(200) NOT NULL DEFAULT '', css_content longtext DEFAULT NULL, source_url varchar(2048) DEFAULT NULL, generated_at datetime DEFAULT NULL, status varchar(20) NOT NULL DEFAULT 'pending', error_message text DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY idx_template (template_key) ) {$charset}; CREATE TABLE wp_f12_prof_optimizer_runs ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, run_id varchar(36) NOT NULL, status varchar(20) NOT NULL DEFAULT 'pending', phase tinyint unsigned NOT NULL DEFAULT 0, phase_detail varchar(255) DEFAULT NULL, settings_before longtext DEFAULT NULL, asset_rules_before longtext DEFAULT NULL, asset_suggestions_before longtext DEFAULT NULL, htaccess_before longtext DEFAULT NULL, critical_css_before longtext DEFAULT NULL, settings_applied longtext DEFAULT NULL, asset_rules_applied longtext DEFAULT NULL, recommendations_before_json longtext DEFAULT NULL, recommendations_resolved longtext DEFAULT NULL, score_before longtext DEFAULT NULL, score_after longtext DEFAULT NULL, recommendations_before int unsigned DEFAULT 0, recommendations_after int unsigned DEFAULT 0, started_at datetime DEFAULT NULL, completed_at datetime DEFAULT NULL, error_message text DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY idx_run_id (run_id), KEY idx_status (status), KEY idx_created (created_at) ) {$charset}; "; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta($sql);

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_f12_prof_crawl_results`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from F12 Profiler