Plesk Database Documentation

This purpose of this site is to rehash the original Plesk Hacker, which catered to Plesk 8.6. Since then the ‘extensive’ database for the Plesk control panel has become even more extensive, and even less documented. Below is a list of the tables in the Plesk database schema with link to a more detailed description.

Additionally, there is a separate section including up-to-date queries that can be used with the Plesk database to provide useful information for administration or basic troubleshooting.

• psa.APSApplicationItems
• psa.APSCatalogUpdates
• psa.APSClientApplicationItems
• psa.APSLicenseTypes
• psa.APSLicenses
• psa.ApiRpcCallsStat
• psa.BackendCache
• psa.BackupsScheduled
• psa.BackupsSettings
• psa.Cards
• psa.ClientsTraffic
• psa.Components
• psa.Configurations
• psa.DashboardPreset
• psa.DashboardPresetConfig
• psa.DatabaseServers
• psa.DomainServices
• psa.DomainsTraffic
• psa.GL_remote_domains
• psa.GL_settings
• psa.IP_Addresses
• psa.IpAddressesCollections
• psa.IpCollections
• psa.Limits
• psa.Logos
• psa.MailLists
• psa.MailMessagesStat
• psa.ModuleSettings
• psa.Modules
• psa.Notes
• psa.Notifications
• psa.PMM
• psa.PMMDefault
• psa.Parameters
• psa.Permissions
• psa.PersistentCache
• psa.PhpSettings
• psa.PhpSettingsParameters
• psa.PlanItemProperties
• psa.PlanItems
• psa.PlansSubscriptions
• psa.PleskPagesStat
• psa.Repository
• psa.SBConfig
• psa.SBResellers
• psa.SBSites
• psa.SSOBranding
• psa.ServiceNodeCache
• psa.ServiceNodeCertificates
• psa.ServiceNodeProperties
• psa.ServiceNodes
• psa.SiteAppFiles
• psa.SiteAppPackages
• psa.SiteAppResources
• psa.SiteApps
• psa.SiteAppsHitsStat
• psa.SitePagesStat
• psa.Skins
• psa.SubscriptionProperties
• psa.Subscriptions
• psa.Templates
• psa.TmplData
• psa.WebApps
• psa.Webmails
• psa.accounts

• psa.actions
• psa.ai_vendor_sources
• psa.anon_ftp
• psa.apsContexts
• psa.apsContextsApplications
• psa.apsResources
• psa.apsResourcesParameters
• psa.apscategories
• psa.badmailfrom
• psa.certificates
• psa.cl_param
• psa.clients
• psa.cp_access
• psa.custom_buttons
• psa.data_bases
• psa.db_users
• psa.disk_usage
• psa.dns_recs
• psa.dns_recs_t
• psa.dns_refs
• psa.dns_zone
• psa.dom_level_usrs
• psa.dom_param
• psa.domainaliases
• psa.domains
• psa.event_handlers
• psa.exp_event
• psa.externalWebmails
• psa.fileSharingUsers
• psa.forwarding
• psa.ftp_users
• psa.hosting
• psa.ip_pool
• psa.itmpl
• psa.itmpl_data
• psa.key_history
• psa.key_history_params
• psa.locales
• psa.log_actions
• psa.log_components
• psa.log_rotation
• psa.longtaskparams
• psa.longtasks
• psa.mail
• psa.mail_aliases
• psa.mail_redir
• psa.mail_resp
• psa.mass_mail
• psa.mass_mail_clients
• psa.mass_mail_domains
• psa.migration_version
• psa.misc
• psa.mn_param
• psa.module_cs_gs_configs
• psa.module_cs_gs_parameters
• psa.module_cs_gs_servers
• psa.module_fileserver_hosts
• psa.module_fileserver_params
• psa.module_fileserver_shares
• psa.module_fileserver_users
• psa.module_fileserver_valid_users
• psa.module_firewall_objects
• psa.module_firewall_rules
• psa.module_vpn_objects

• psa.module_watchdog_disk
• psa.module_watchdog_disk_event
• psa.module_watchdog_param
• psa.module_watchdog_report
• psa.module_watchdog_service
• psa.module_watchdog_service_event
• psa.module_watchdog_sys_stat
• psa.password_secrets
• psa.pd_users
• psa.protected_dirs
• psa.report
• psa.report_auto
• psa.report_section
• psa.resp_attach
• psa.resp_forward
• psa.resp_freq
• psa.secret_keys
• psa.sessions
• psa.siteapppackages_apscategories
• psa.smb_apsBundleFilterItems
• psa.smb_apsBundleFilters
• psa.smb_apsCategories
• psa.smb_apsContexts
• psa.smb_apsImportedResources
• psa.smb_apsImportedSettings
• psa.smb_apsInstanceErrors
• psa.smb_apsInstances
• psa.smb_apsMetas
• psa.smb_apsPackageUpdates
• psa.smb_apsPackages
• psa.smb_apsPackagesCategories
• psa.smb_apsProvisionEnvironments
• psa.smb_apsProvisions
• psa.smb_apsResourceParameters
• psa.smb_apsResources
• psa.smb_apsSettings
• psa.smb_componentUpdates
• psa.smb_emailAliases
• psa.smb_fileSharingUnlistedFiles
• psa.smb_generalPermissions
• psa.smb_locales
• psa.smb_productUpgrades
• psa.smb_roleGeneralPermissions
• psa.smb_roleServicePermissions
• psa.smb_roles
• psa.smb_serviceEntryPoints
• psa.smb_serviceInstances
• psa.smb_servicePermissionAccounts
• psa.smb_servicePermissions
• psa.smb_serviceProviders
• psa.smb_settings
• psa.smb_userServicePermissions
• psa.smb_users
• psa.smtp_poplocks
• psa.spamfilter
• psa.spamfilter_preferences
• psa.subdomains
• psa.suspend_handler_history
• psa.sys_users
• psa.upgrade_history
• psa.web_users
• psa.webalizer_group_referrer
• psa.webalizer_hidden_referrer