1)脚本rootslm-server:/data# cat gitea_test.py import sqlite3 conn sqlite3.connect(/data/gitea/data/custom/gitea.db) cursor conn.cursor() cursor.execute( SELECT name, SUM(pgsize)/1024.0/1024.0 AS size_mb FROM dbstat GROUP BY name ORDER BY size_mb DESC; ) for row in cursor.fetchall(): print(f{row[0]:40} {row[1]:.2f} MB) conn.close()2)rootslm-server:/data# python gitea_test.py action 896.19 MB IDX_action_au_r_c_u_d 24.89 MB IDX_action_c_u_d 20.60 MB IDX_action_r_u_d 16.09 MB IDX_action_c_u 13.66 MB IDX_action_user_id 12.46 MB commit_status 12.11 MB IDX_action_comment_id 11.58 MB hook_task 5.94 MB UQE_commit_status_repo_sha_index 2.93 MB IDX_commit_status_sha 2.82 MB IDX_commit_status_context_hash 2.76 MB commit_status_summary 1.27 MB IDX_commit_status_updated_unix 0.71 MB IDX_commit_status_created_unix 0.71 MB lfs_meta_object 0.64 MB UQE_lfs_meta_object_s 0.60 MB IDX_lfs_meta_object_oid 0.59 MB UQE_commit_status_summary_repo_id_sha 0.53 MB UQE_commit_status_index_repo_sha 0.53 MB IDX_commit_status_repo_id 0.52 MB IDX_commit_status_index 0.52 MB commit_status_index 0.50 MB IDX_commit_status_summary_sha 0.50 MB notice 0.34 MB IDX_lfs_meta_object_updated_unix 0.10 MB IDX_commit_status_index_max_index 0.10 MB sqlite_schema 0.09 MB IDX_commit_status_summary_repo_id 0.09 MB IDX_lfs_meta_object_repository_id 0.07 MB IDX_notice_created_unix 0.05 MB UQE_hook_task_uuid 0.04 MB branch 0.04 MB user 0.04 MB release 0.03 MB watch 0.02 MB lfs_lock 0.02 MB access 0.02 MB IDX_watch_updated_unix 0.02 MB IDX_watch_created_unix 0.02 MB task 0.01 MB language_stat 0.01 MB UQE_watch_watch 0.01 MB UQE_release_n 0.01 MB UQE_branch_s 0.01 MB UQE_access_s 0.01 MB IDX_release_tag_name 0.01 MB IDX_release_sha1 0.01 MB IDX_hook_task_hook_id 0.01 MB webhook 0.00 MB webauthn_credential 0.00 MB version 0.00 MB user_setting 0.00 MB user_redirect 0.00 MB user_open_id 0.00 MB user_blocking 0.00 MB user_badge 0.00 MB upload 0.00 MB two_factor 0.00 MB tracked_time 0.00 MB topic 0.00 MB team_user 0.00 MB team_unit 0.00 MB team_repo 0.00 MB team_invite 0.00 MB team 0.00 MB system_setting 0.00 MB stopwatch 0.00 MB star 0.00 MB sqlite_sequence 0.00 MB sqlite_autoindex_session_1 0.00 MB sqlite_autoindex_repo_topic_1 0.00 MB sqlite_autoindex_package_blob_upload_1 0.00 MB sqlite_autoindex_gpg_key_import_1 0.00 MB sqlite_autoindex_external_login_user_1 0.00 MB sqlite_autoindex_email_hash_1 0.00 MB sqlite_autoindex_auth_token_1 0.00 MB sqlite_autoindex_app_state_1 0.00 MB session 0.00 MB secret 0.00 MB review_state 0.00 MB review 0.00 MB repository 0.00 MB repo_unit 0.00 MB repo_transfer 0.00 MB repo_topic 0.00 MB repo_redirect 0.00 MB repo_license 0.00 MB repo_indexer_status 0.00 MB repo_archiver 0.00 MB renamed_branch 0.00 MB reaction 0.00 MB push_mirror 0.00 MB pull_request 0.00 MB pull_auto_merge 0.00 MB public_key 0.00 MB protected_tag 0.00 MB protected_branch 0.00 MB project_issue 0.00 MB project_board 0.00 MB project 0.00 MB package_version 0.00 MB package_property 0.00 MB package_file 0.00 MB package_cleanup_rule 0.00 MB package_blob_upload 0.00 MB package_blob 0.00 MB package 0.00 MB org_user 0.00 MB oauth2_grant 0.00 MB oauth2_authorization_code 0.00 MB oauth2_application 0.00 MB notification 0.00 MB mirror 0.00 MB milestone 0.00 MB login_source 0.00 MB label 0.00 MB issue_watch 0.00 MB issue_user 0.00 MB issue_label 0.00 MB issue_index 0.00 MB issue_dependency 0.00 MB issue_content_history 0.00 MB issue_assignees 0.00 MB issue 0.00 MB gpg_key_import 0.00 MB gpg_key 0.00 MB follow 0.00 MB external_login_user 0.00 MB email_hash 0.00 MB email_address 0.00 MB deploy_key 0.00 MB dbfs_meta 0.00 MB dbfs_data 0.00 MB comment 0.00 MB collaboration 0.00 MB badge 0.00 MB auth_token 0.00 MB attachment 0.00 MB app_state 0.00 MB action_variable 0.00 MB action_tasks_version 0.00 MB action_task_step 0.00 MB action_task_output 0.00 MB action_task 0.00 MB action_schedule_spec 0.00 MB action_schedule 0.00 MB action_runner_token 0.00 MB action_runner 0.00 MB action_run_job 0.00 MB action_run_index 0.00 MB action_run 0.00 MB action_artifact 0.00 MB access_token 0.00 MB UQE_webauthn_credential_s 0.00 MB UQE_user_setting_key_userid 0.00 MB UQE_user_redirect_s 0.00 MB UQE_user_open_id_uri 0.00 MB UQE_user_name 0.00 MB UQE_user_lower_name 0.00 MB UQE_user_blocking_block 0.00 MB UQE_upload_uuid 0.00 MB UQE_two_factor_uid 0.00 MB UQE_topic_name 0.00 MB UQE_team_user_s 0.00 MB UQE_team_unit_s 0.00 MB UQE_team_repo_s 0.00 MB UQE_team_invite_team_mail 0.00 MB UQE_system_setting_setting_key 0.00 MB UQE_star_s 0.00 MB UQE_secret_owner_repo_name 0.00 MB UQE_review_state_pull_commit_user 0.00 MB UQE_repository_s 0.00 MB UQE_repo_redirect_s 0.00 MB UQE_repo_license_s 0.00 MB UQE_repo_archiver_s 0.00 MB UQE_reaction_s 0.00 MB UQE_pull_auto_merge_pull_id 0.00 MB UQE_protected_branch_s 0.00 MB UQE_package_version_s 0.00 MB UQE_package_s 0.00 MB UQE_package_file_s 0.00 MB UQE_package_cleanup_rule_s 0.00 MB UQE_package_blob_sha512 0.00 MB UQE_package_blob_sha256 0.00 MB UQE_package_blob_sha1 0.00 MB UQE_package_blob_md5 0.00 MB UQE_org_user_s 0.00 MB UQE_oauth2_grant_user_application 0.00 MB UQE_oauth2_authorization_code_code 0.00 MB UQE_oauth2_application_client_id 0.00 MB UQE_login_source_name 0.00 MB UQE_language_stat_s 0.00 MB UQE_issue_watch_watch 0.00 MB UQE_issue_user_uid_to_issue 0.00 MB UQE_issue_repo_index 0.00 MB UQE_issue_label_s 0.00 MB UQE_issue_dependency_issue_dependency 0.00 MB UQE_follow_follow 0.00 MB UQE_email_hash_email 0.00 MB UQE_email_address_lower_email 0.00 MB UQE_email_address_email 0.00 MB UQE_deploy_key_s 0.00 MB UQE_dbfs_meta_full_path 0.00 MB UQE_collaboration_s 0.00 MB UQE_badge_slug 0.00 MB UQE_attachment_uuid 0.00 MB UQE_action_variable_owner_repo_name 0.00 MB UQE_action_tasks_version_owner_repo 0.00 MB UQE_action_task_token_hash 0.00 MB UQE_action_task_step_task_index 0.00 MB UQE_action_task_output_task_id_output_key 0.00 MB UQE_action_runner_uuid 0.00 MB UQE_action_runner_token_token 0.00 MB UQE_action_runner_token_hash 0.00 MB UQE_action_run_repo_index 0.00 MB UQE_action_artifact_runid_name_path 0.00 MB UQE_access_token_token_hash 0.00 MB IDX_webhook_updated_unix 0.00 MB IDX_webhook_repo_id 0.00 MB IDX_webhook_owner_id 0.00 MB IDX_webhook_is_active 0.00 MB IDX_webhook_created_unix 0.00 MB IDX_webauthn_credential_user_id 0.00 MB IDX_webauthn_credential_updated_unix 0.00 MB IDX_webauthn_credential_credential_id 0.00 MB IDX_webauthn_credential_created_unix 0.00 MB IDX_user_updated_unix 0.00 MB IDX_user_setting_user_id 0.00 MB IDX_user_setting_setting_key 0.00 MB IDX_user_redirect_lower_name 0.00 MB IDX_user_open_id_uid 0.00 MB IDX_user_last_login_unix 0.00 MB IDX_user_is_active 0.00 MB IDX_user_created_unix 0.00 MB IDX_user_blocking_created_unix 0.00 MB IDX_user_badge_user_id 0.00 MB IDX_two_factor_updated_unix 0.00 MB IDX_two_factor_created_unix 0.00 MB IDX_tracked_time_user_id 0.00 MB IDX_tracked_time_issue_id 0.00 MB IDX_topic_updated_unix 0.00 MB IDX_topic_created_unix 0.00 MB IDX_team_user_org_id 0.00 MB IDX_team_unit_org_id 0.00 MB IDX_team_repo_org_id 0.00 MB IDX_team_org_id 0.00 MB IDX_team_invite_updated_unix 0.00 MB IDX_team_invite_token 0.00 MB IDX_team_invite_team_id 0.00 MB IDX_team_invite_org_id 0.00 MB IDX_team_invite_created_unix 0.00 MB IDX_task_status 0.00 MB IDX_task_repo_id 0.00 MB IDX_task_owner_id 0.00 MB IDX_task_doer_id 0.00 MB IDX_stopwatch_user_id 0.00 MB IDX_stopwatch_issue_id 0.00 MB IDX_star_created_unix 0.00 MB IDX_secret_repo_id 0.00 MB IDX_secret_owner_id 0.00 MB IDX_review_updated_unix 0.00 MB IDX_review_state_pull_id 0.00 MB IDX_review_reviewer_id 0.00 MB IDX_review_issue_id 0.00 MB IDX_review_created_unix 0.00 MB IDX_repository_updated_unix 0.00 MB IDX_repository_template_id 0.00 MB IDX_repository_owner_id 0.00 MB IDX_repository_original_service_type 0.00 MB IDX_repository_name 0.00 MB IDX_repository_lower_name 0.00 MB IDX_repository_is_template 0.00 MB IDX_repository_is_private 0.00 MB IDX_repository_is_mirror 0.00 MB IDX_repository_is_fork 0.00 MB IDX_repository_is_empty 0.00 MB IDX_repository_is_archived 0.00 MB IDX_repository_fork_id 0.00 MB IDX_repository_created_unix 0.00 MB IDX_repo_unit_s 0.00 MB IDX_repo_unit_created_unix 0.00 MB IDX_repo_transfer_updated_unix 0.00 MB IDX_repo_transfer_created_unix 0.00 MB IDX_repo_redirect_lower_name 0.00 MB IDX_repo_license_updated_unix 0.00 MB IDX_repo_license_created_unix 0.00 MB IDX_repo_indexer_status_s 0.00 MB IDX_repo_archiver_repo_id 0.00 MB IDX_repo_archiver_created_unix 0.00 MB IDX_renamed_branch_repo_id 0.00 MB IDX_release_repo_id 0.00 MB IDX_release_publisher_id 0.00 MB IDX_release_original_author_id 0.00 MB IDX_release_created_unix 0.00 MB IDX_reaction_user_id 0.00 MB IDX_reaction_type 0.00 MB IDX_reaction_original_author_id 0.00 MB IDX_reaction_original_author 0.00 MB IDX_reaction_issue_id 0.00 MB IDX_reaction_created_unix 0.00 MB IDX_reaction_comment_id 0.00 MB IDX_push_mirror_repo_id 0.00 MB IDX_push_mirror_last_update 0.00 MB IDX_pull_request_merger_id 0.00 MB IDX_pull_request_merged_unix 0.00 MB IDX_pull_request_issue_id 0.00 MB IDX_pull_request_head_repo_id 0.00 MB IDX_pull_request_has_merged 0.00 MB IDX_pull_request_base_repo_id 0.00 MB IDX_pull_auto_merge_doer_id 0.00 MB IDX_public_key_owner_id 0.00 MB IDX_public_key_fingerprint 0.00 MB IDX_project_updated_unix 0.00 MB IDX_project_title 0.00 MB IDX_project_repo_id 0.00 MB IDX_project_owner_id 0.00 MB IDX_project_issue_project_id 0.00 MB IDX_project_issue_project_board_id 0.00 MB IDX_project_issue_issue_id 0.00 MB IDX_project_is_closed 0.00 MB IDX_project_created_unix 0.00 MB IDX_project_board_updated_unix 0.00 MB IDX_project_board_project_id 0.00 MB IDX_project_board_created_unix 0.00 MB IDX_package_version_package_id 0.00 MB IDX_package_version_lower_version 0.00 MB IDX_package_version_is_internal 0.00 MB IDX_package_version_created_unix 0.00 MB IDX_package_type 0.00 MB IDX_package_repo_id 0.00 MB IDX_package_property_ref_type 0.00 MB IDX_package_property_ref_id 0.00 MB IDX_package_property_name 0.00 MB IDX_package_owner_id 0.00 MB IDX_package_lower_name 0.00 MB IDX_package_file_version_id 0.00 MB IDX_package_file_lower_name 0.00 MB IDX_package_file_created_unix 0.00 MB IDX_package_file_composite_key 0.00 MB IDX_package_file_blob_id 0.00 MB IDX_package_cleanup_rule_type 0.00 MB IDX_package_cleanup_rule_owner_id 0.00 MB IDX_package_cleanup_rule_enabled 0.00 MB IDX_package_blob_upload_updated_unix 0.00 MB IDX_package_blob_hash_sha512 0.00 MB IDX_package_blob_hash_sha256 0.00 MB IDX_package_blob_hash_sha1 0.00 MB IDX_package_blob_hash_md5 0.00 MB IDX_package_blob_created_unix 0.00 MB IDX_org_user_uid 0.00 MB IDX_org_user_org_id 0.00 MB IDX_org_user_is_public 0.00 MB IDX_oauth2_grant_user_id 0.00 MB IDX_oauth2_grant_application_id 0.00 MB IDX_oauth2_authorization_code_valid_until 0.00 MB IDX_oauth2_application_updated_unix 0.00 MB IDX_oauth2_application_uid 0.00 MB IDX_oauth2_application_created_unix 0.00 MB IDX_notification_u_s_uu 0.00 MB IDX_notification_idx_notification_user_id 0.00 MB IDX_notification_idx_notification_updated_by 0.00 MB IDX_notification_idx_notification_status 0.00 MB IDX_notification_idx_notification_source 0.00 MB IDX_notification_idx_notification_repo_id 0.00 MB IDX_notification_idx_notification_issue_id 0.00 MB IDX_notification_idx_notification_commit_id 0.00 MB IDX_mirror_updated_unix 0.00 MB IDX_mirror_repo_id 0.00 MB IDX_mirror_next_update_unix 0.00 MB IDX_milestone_updated_unix 0.00 MB IDX_milestone_repo_id 0.00 MB IDX_milestone_created_unix 0.00 MB IDX_login_source_updated_unix 0.00 MB IDX_login_source_is_sync_enabled 0.00 MB IDX_login_source_is_active 0.00 MB IDX_login_source_created_unix 0.00 MB IDX_lfs_lock_repo_id 0.00 MB IDX_lfs_lock_owner_id 0.00 MB IDX_language_stat_repo_id 0.00 MB IDX_language_stat_language 0.00 MB IDX_language_stat_created_unix 0.00 MB IDX_label_updated_unix 0.00 MB IDX_label_repo_id 0.00 MB IDX_label_org_id 0.00 MB IDX_label_created_unix 0.00 MB IDX_issue_user_uid 0.00 MB IDX_issue_user_issue_id 0.00 MB IDX_issue_updated_unix 0.00 MB IDX_issue_repo_id 0.00 MB IDX_issue_poster_id 0.00 MB IDX_issue_original_author_id 0.00 MB IDX_issue_milestone_id 0.00 MB IDX_issue_is_pull 0.00 MB IDX_issue_is_closed 0.00 MB IDX_issue_index_max_index 0.00 MB IDX_issue_deadline_unix 0.00 MB IDX_issue_created_unix 0.00 MB IDX_issue_content_history_issue_id 0.00 MB IDX_issue_content_history_edited_unix 0.00 MB IDX_issue_content_history_comment_id 0.00 MB IDX_issue_closed_unix 0.00 MB IDX_issue_assignees_issue_id 0.00 MB IDX_issue_assignees_assignee_id 0.00 MB IDX_gpg_key_owner_id 0.00 MB IDX_gpg_key_key_id 0.00 MB IDX_follow_created_unix 0.00 MB IDX_external_login_user_user_id 0.00 MB IDX_external_login_user_provider 0.00 MB IDX_email_address_uid 0.00 MB IDX_deploy_key_repo_id 0.00 MB IDX_deploy_key_key_id 0.00 MB IDX_dbfs_data_meta_offset 0.00 MB IDX_comment_updated_unix 0.00 MB IDX_comment_type 0.00 MB IDX_comment_review_id 0.00 MB IDX_comment_ref_repo_id 0.00 MB IDX_comment_ref_issue_id 0.00 MB IDX_comment_ref_comment_id 0.00 MB IDX_comment_poster_id 0.00 MB IDX_comment_issue_id 0.00 MB IDX_comment_dependent_issue_id 0.00 MB IDX_comment_created_unix 0.00 MB IDX_collaboration_user_id 0.00 MB IDX_collaboration_updated_unix 0.00 MB IDX_collaboration_repo_id 0.00 MB IDX_collaboration_created_unix 0.00 MB IDX_branch_is_deleted 0.00 MB IDX_branch_deleted_unix 0.00 MB IDX_auth_token_user_id 0.00 MB IDX_auth_token_expires_unix 0.00 MB IDX_attachment_uploader_id 0.00 MB IDX_attachment_repo_id 0.00 MB IDX_attachment_release_id 0.00 MB IDX_attachment_issue_id 0.00 MB IDX_attachment_comment_id 0.00 MB IDX_action_variable_repo_id 0.00 MB IDX_action_tasks_version_repo_id 0.00 MB IDX_action_task_updated 0.00 MB IDX_action_task_token_last_eight 0.00 MB IDX_action_task_stopped_log_expired 0.00 MB IDX_action_task_step_task_id 0.00 MB IDX_action_task_step_status 0.00 MB IDX_action_task_step_repo_id 0.00 MB IDX_action_task_step_index 0.00 MB IDX_action_task_status 0.00 MB IDX_action_task_started 0.00 MB IDX_action_task_runner_id 0.00 MB IDX_action_task_repo_id 0.00 MB IDX_action_task_owner_id 0.00 MB IDX_action_task_output_task_id 0.00 MB IDX_action_task_commit_sha 0.00 MB IDX_action_schedule_spec_schedule_id 0.00 MB IDX_action_schedule_spec_repo_id 0.00 MB IDX_action_schedule_spec_next 0.00 MB IDX_action_schedule_repo_id 0.00 MB IDX_action_schedule_owner_id 0.00 MB IDX_action_runner_token_repo_id 0.00 MB IDX_action_runner_token_owner_id 0.00 MB IDX_action_runner_repo_id 0.00 MB IDX_action_runner_owner_id 0.00 MB IDX_action_runner_last_online 0.00 MB IDX_action_runner_last_active 0.00 MB IDX_action_run_workflow_id 0.00 MB IDX_action_run_trigger_user_id 0.00 MB IDX_action_run_status 0.00 MB IDX_action_run_repo_id 0.00 MB IDX_action_run_ref 0.00 MB IDX_action_run_owner_id 0.00 MB IDX_action_run_job_updated 0.00 MB IDX_action_run_job_status 0.00 MB IDX_action_run_job_run_id 0.00 MB IDX_action_run_job_repo_id 0.00 MB IDX_action_run_job_owner_id 0.00 MB IDX_action_run_job_commit_sha 0.00 MB IDX_action_run_index_max_index 0.00 MB IDX_action_run_index 0.00 MB IDX_action_run_approved_by 0.00 MB IDX_action_artifact_updated_unix 0.00 MB IDX_action_artifact_status 0.00 MB IDX_action_artifact_run_id 0.00 MB IDX_action_artifact_repo_id 0.00 MB IDX_action_artifact_expired_unix 0.00 MB IDX_action_artifact_artifact_path 0.00 MB IDX_action_artifact_artifact_name 0.00 MB IDX_access_token_updated_unix 0.00 MB IDX_access_token_uid 0.00 MB IDX_access_token_token_last_eight 0.00 MB IDX_access_token_created_unix 0.00 MB
