Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Settings for the table structure (list of columns).
Table structure
Documentation Whether the table structure actions should be hidden. Restore default value
Documentation Whether column comments should be shown in table structure view Restore default value
Default transformations
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value

pg_tracking

# Name Type Collation Attributes Null Default Comments Extra Action
1 bigint(20) UNSIGNED No None AUTO_INCREMENT Change Change Drop Drop
2 varchar(100) utf8mb4_unicode_ci No None Change Change Drop Drop
3 varchar(10) utf8mb4_unicode_ci No BDT Change Change Drop Drop
4 varchar(50) utf8mb4_unicode_ci No main Change Change Drop Drop
5 varchar(255) utf8mb4_unicode_ci No None Change Change Drop Drop
6 varchar(255) utf8mb4_unicode_ci No Change Change Drop Drop
7 varchar(255) utf8mb4_unicode_ci No Change Change Drop Drop
8 datetime Yes NULL Change Change Drop Drop
9 datetime Yes NULL Change Change Drop Drop
10 varchar(255) utf8mb4_unicode_ci No Change Change Drop Drop
11 varchar(255) utf8mb4_unicode_ci No Change Change Drop Drop
12 datetime Yes NULL Change Change Drop Drop
13 datetime Yes NULL Change Change Drop Drop
14 varchar(255) utf8mb4_unicode_ci No Change Change Drop Drop
15 varchar(255) utf8mb4_unicode_ci No Change Change Drop Drop
16 decimal(18,2) Yes NULL Change Change Drop Drop
17 varchar(255) utf8mb4_unicode_ci No Change Change Drop Drop
18 varchar(255) utf8mb4_unicode_ci No Change Change Drop Drop
19 varchar(255) utf8mb4_unicode_ci No Change Change Drop Drop
20 int(11) Yes NULL Change Change Drop Drop
21 int(11) Yes NULL Change Change Drop Drop
22 int(11) Yes NULL Change Change Drop Drop
23 date Yes NULL Change Change Drop Drop
24 varchar(255) utf8mb4_unicode_ci No Change Change Drop Drop
25 timestamp No current_timestamp() Change Change Drop Drop
26 timestamp No current_timestamp() ON UPDATE CURRENT_TIMESTAMP() Change Change Drop Drop
With selected: With selected:
Add column  Add column(s)  
Indexes Documentation
Action Keyname Type Unique Packed Column Cardinality Collation Null Comment
Edit Edit Rename Rename Drop Drop PRIMARY BTREE Yes No id 2489259 A No
Edit Edit Rename Rename Drop Drop uq_currency_report_brand_reference BTREE Yes No currency 462 A No
report_type 462 A No
brand 6972 A No
reference 2489259 A No
Edit Edit Rename Rename Drop Drop idx_record_date BTREE No No record_date 370 A Yes
Edit Edit Rename Rename Drop Drop idx_pg_status BTREE No No pg_status 35059 A No
Edit Edit Rename Rename Drop Drop idx_channel BTREE No No channel 234 A No
Edit Edit Rename Rename Drop Drop idx_pg_pic BTREE No No pg_pic 1182 A No
Edit Edit Rename Rename Drop Drop idx_record_status_channel_speed BTREE No No record_date 22425 A Yes
pg_status 118536 A No
channel 165950 A No
pg_speed_seconds 2489259 A Yes
Edit Edit Rename Rename Drop Drop idx_data_filters BTREE No No record_date 17654 A Yes
brand (32) 43671 A No
pg_status (64) 248925 A No
channel (64) 497851 A No
pg_pic (64) 1244629 A No
updated_at 2489259 A No
id 2489259 A No
Edit Edit Rename Rename Drop Drop idx_rank_query BTREE No No record_date 24404 A Yes
brand (32) 28612 A No
channel (64) 103719 A No
pg_status (64) 177804 A No
pg_pic (64) 829753 A No
pg_speed_seconds 2489259 A Yes
Edit Edit Rename Rename Drop Drop idx_record_updated BTREE No No record_date 8583 A Yes
updated_at 2489259 A No
id 2489259 A No
Edit Edit Rename Rename Drop Drop idx_currency_record_status_channel_speed BTREE No No currency 448 A No
record_date 21835 A Yes
pg_status 82975 A No
channel 124462 A No
pg_speed_seconds 2489259 A Yes
Edit Edit Rename Rename Drop Drop idx_currency_data_filters BTREE No No currency 288 A No
record_date 15271 A Yes
brand (32) 31509 A No
pg_status (64) 124462 A No
channel (64) 414876 A No
pg_pic (64) 1244629 A No
updated_at 2489259 A No
id 2489259 A No
Edit Edit Rename Rename Drop Drop idx_currency_rank_query BTREE No No currency 382 A No
record_date 26202 A Yes
brand (32) 38296 A No
channel (64) 99570 A No
pg_status (64) 355608 A No
pg_pic (64) 1244629 A No
pg_speed_seconds 2489259 A Yes
Edit Edit Rename Rename Drop Drop idx_currency_record_updated BTREE No No currency 2 A No
record_date 8495 A Yes
updated_at 2489259 A No
id 2489259 A No
Edit Edit Rename Rename Drop Drop idx_report_type BTREE No No report_type 2 A No
Edit Edit Rename Rename Drop Drop idx_report_currency_record_status_channel_speed BTREE No No report_type 2 A No
currency 384 A No
record_date 23935 A Yes
pg_status 95740 A No
channel 113148 A No
pg_speed_seconds 2489259 A Yes
Edit Edit Rename Rename Drop Drop idx_currency_report_reference BTREE No No currency 488 A No
report_type 488 A No
reference (191) 2489259 A No
Edit Edit Rename Rename Drop Drop idx_currency_report_date_brand BTREE No No currency 2 A No
report_type 2 A No
record_date 816 A Yes
brand 7071 A No
Edit Edit Rename Rename Drop Drop idx_pg_report_filters BTREE No No report_type 2 A No
currency 392 A No
record_date 25929 A Yes
brand 42190 A No
channel 73213 A No
pg_status 311157 A No
Edit Edit Rename Rename Drop Drop idx_report_page_filters BTREE No No report_type 2 A No
currency 422 A No
record_date 25929 A Yes
brand 27354 A No
channel 92194 A No
pg_status 276584 A No
Edit Edit Rename Rename Drop Drop idx_error_pending_filters BTREE No No currency 338 A No
report_type 338 A No
updated_at 2489259 A No
record_date 2489259 A Yes
brand 2489259 A No
channel 1244629 A No
pg_status 2489259 A No
Edit Edit Rename Rename Drop Drop idx_pg_report_fast BTREE No No report_type 2 A No
currency 412 A No
record_date 26481 A Yes
pg_status 82975 A No
channel 118536 A No
brand 248925 A No
Edit Edit Rename Rename Drop Drop idx_analytic_filters BTREE No No report_type 2 A No
currency 400 A No
record_date 26481 A Yes
pg_status 80298 A No
channel 138292 A No
brand 355608 A No
Edit Edit Rename Rename Drop Drop idx_data_date_currency_updated BTREE No No record_date 9838 A Yes
currency 14306 A No
updated_at 2489259 A No
id 2489259 A No
Edit Edit Rename Rename Drop Drop idx_data_date_currency_type_updated BTREE No No record_date 10637 A Yes
currency 19447 A No
report_type 17908 A No
updated_at 2489259 A No
id 2489259 A No
Edit Edit Rename Rename Drop Drop idx_data_date_currency_reference BTREE No No record_date 410 A Yes
currency 810 A No
reference (191) 2489259 A No
id 2489259 A No
Edit Edit Rename Rename Drop Drop idx_analytic_fast BTREE No No report_type 2 A No
currency 402 A No
record_date 26202 A Yes
channel 35560 A No
pg_status 146427 A No
brand 311157 A No
Edit Edit Rename Rename Drop Drop idx_data_currency_reference BTREE No No currency 682 A No
reference (191) 2489259 A No
updated_at 2489259 A No
id 2489259 A No
Edit Edit Rename Rename Drop Drop idx_data_currency_pg_chart BTREE No No currency 598 A No
pg_chart_id (191) 2489259 A No
updated_at 2489259 A No
id 2489259 A No
Edit Edit Rename Rename Drop Drop idx_data_currency_payment_chart BTREE No No currency 636 A No
payment_chart_id (191) 2489259 A No
updated_at 2489259 A No
id 2489259 A No
Edit Edit Rename Rename Drop Drop idx_monitor_amount_flags BTREE No No report_type 2 A No
currency 476 A No
record_date 13170 A Yes
pg_amount 311157 A Yes
Create an index on columns
Partitions Documentation
Information
Space usage
Data 834.0 MiB
Index 11.3 GiB
Overhead 2.3 GiB
Effective 9.8 GiB
Total 12.1 GiB
Optimize table Optimize table
Row statistics
Format dynamic
Collation utf8mb4_unicode_ci
Next autoindex 1,248,694,521
Creation Jun 10, 2026 at 09:42 AM
Last update Oct 20, 2026 at 01:09 AM
Last check Oct 19, 2026 at 08:09 PM