AlexeySetevoi

Debian and derivates on WSL2 (Windows 11) can have issues running docker distributed by Rancher Desktop. If you have error messages like the below, install dependencies to fix that.

"docker-credential-secretservice: error while loading shared libraries: libsecret-1.so.0" or "error getting credentials - err: exit status 1, out: GDBus.Error:org.freedesktop.DBus.Error.ServiceUnknown: The name org.freedesktop.secrets was not provided by any .service files"

or that

"error getting credentials - err: exit status 1, out: `Failed to execute child process "dbus-launch"

AlexeySetevoi

{
    "registry-mirrors" : [
        "https://cr.yandex/mirror",
        "https://dockerhub.timeweb.cloud",
        "https://huecker.io",
        "https://noohub.ru",
        "https://dcr-px.ru",
        "https://mirror.gcr.io",
        "https://quay.io",
        "https://registry.access.redhat.com",

AlexeySetevoi

** Find commmonly accessed tables and their use of indexes:

SELECT relname,seq_tup_read,idx_tup_fetch,cast(idx_tup_fetch AS numeric) / (idx_tup_fetch + seq_tup_read) AS idx_tup_pct FROM pg_stat_user_tables WHERE (idx_tup_fetch + seq_tup_read)>0 ORDER BY idx_tup_pct;

Returns output like:

       relname        | seq_tup_read | idx_tup_fetch |      idx_tup_pct       
----------------------+--------------+---------------+------------------------
 schema_migrations    |          817 |             0 | 0.00000000000000000000
 user_device_photos   |          349 |             0 | 0.00000000000000000000