wp_directrelay_analytics
StaticStores analytics or statistics data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| bucket_hour | DATETIME | NO |
| endpoint | VARCHAR(128) | NO |
| method | VARCHAR(10) | NO |
| http_status | SMALLINT | NO |
| hits | INT UNSIGNED | NO |
| total_ms | INT UNSIGNED | NO |
CREATE TABLE Statement
CREATE TABLE wp_directrelay_analytics ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, bucket_hour DATETIME NOT NULL, key_id BIGINT UNSIGNED DEFAULT NULL, endpoint VARCHAR(128) NOT NULL DEFAULT '', method VARCHAR(10) NOT NULL DEFAULT '', http_status SMALLINT NOT NULL DEFAULT 200, hits INT UNSIGNED NOT NULL DEFAULT 1, total_ms INT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY uq_bucket (bucket_hour, key_id, endpoint, method, http_status), KEY idx_hour (bucket_hour) ) $c;" );
Safe to delete?
If you have uninstalled DirectRelay – n8n WordPress Plugin: Workflow Automation, REST API, Webhooks & AI Agents, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_directrelay_analytics`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from DirectRelay – n8n WordPress Plugin: Workflow Automation, REST API, Webhooks & AI Agents