Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nFopu-0005hO-4p for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Feb 2022 03:00:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nFops-0004CC-Lv for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Feb 2022 03:00:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nFops-0004C2-0k for pgsql-hackers@lists.postgresql.org; Fri, 04 Feb 2022 03:00:32 +0000 Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nFopm-0003Za-BV for pgsql-hackers@lists.postgresql.org; Fri, 04 Feb 2022 03:00:30 +0000 Received: by mail-ej1-x62e.google.com with SMTP id k25so14780432ejp.5 for ; Thu, 03 Feb 2022 19:00:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=message-id:date:mime-version:user-agent:subject:content-language :from:to:cc:references:in-reply-to:content-transfer-encoding; bh=fWQlc4o9C28fFrY6NSnATi2FNabfhn5To8pJcdikhTk=; b=ERee6SzT/Xg4LOiHBLdP4eFi81uE7n84BkxOXzISP5W5u18kRAkSNvUsEcvLdTIK0M 8M3rrsiCKi8T0bd71TxkGdjE0GLKwmPi80SrRjuPAld11wJbBuQcOMzqBW0wtGDA/00U smtOvkhuYOi5gnX41UyyUktsxJORoLXBIZDkIXbEeENezmgw2b0TQ0kYK1NQCDhKQfl3 O26jjnnKEcKGt9iE+K1Mn/yX5sys1C4NvujJu1Ph4PZ2uAARpQ20wuJzfQ/rqawLyX9G GID/8uzASFQjzNV4ueS8RZOPC6NC+Jv6qn1MWGiY4MNR02+krC1EVBZsIuvZNv3nHJin P2bA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:date:mime-version:user-agent:subject :content-language:from:to:cc:references:in-reply-to :content-transfer-encoding; bh=fWQlc4o9C28fFrY6NSnATi2FNabfhn5To8pJcdikhTk=; b=3/F2oUBKXh6l3xs49s+vKiSxFsAAr+YT5Xc+zsfYgjSP/aSYFD7KVdENKKIyertIOH g1ZKMfSlKU31Sy6htqBewVMzoU42cfCub+0U09sKH+j/pXPqDCkPnIgRYjOQ1Iwe+Qe4 qCcrtt2gbY3B6md02+ysCZ+Q19qIw+OSNsWQBbtX4mKWHNRcGBSFDoWNV+EvmkcolTuq /OR808j0zY7XvQxlUbP0sHdFc2PqjF4+Gf6sfUW7UF5BV59WN0XbIA6bN5FWjMpidSiY xdd3SkARuCOkqHzcjzTs6lb6tfqkrL2lyL2BtjQsVQRyYfbTnheF75pb7izR6mSG56Yt Nzcw== X-Gm-Message-State: AOAM531fXHqCnt5v4x70Y/f5GG9aDCBSpbU09ACi2uvbDSJX0LQFGmiZ 71Fn340hpXkna3k3vb7o6QuZAKuiBRibaI/nUpoESmwdr4EP5pFMaM5+ikJwhm/waHFUHP0u0fG hWZVNJlKTkx4kxkJ01c2XJ4f+YPh1cKjK9+IvVLjB54bC9h2I5GvN8aXa+Ws591ipfXn/Sy4MqN y71IgXZZgdSndo4zE4Lj8Kcpn4yUOls2kxUcCfliPLHQnxBCCEZYAf X-Google-Smtp-Source: ABdhPJyHi4WgmZ4gG21VjmW4B3St6+Gw2XsTzk3/3ki9Q340Pahlvt9RRxarPktuRA68dK6YO3+r3w== X-Received: by 2002:a17:906:6708:: with SMTP id a8mr693937ejp.127.1643943624955; Thu, 03 Feb 2022 19:00:24 -0800 (PST) Received: from [10.137.0.18] (ip-86-49-251-241.net.upcbroadband.cz. [86.49.251.241]) by smtp.gmail.com with ESMTPSA id q6sm193488ejz.150.2022.02.03.19.00.23 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 03 Feb 2022 19:00:24 -0800 (PST) Message-ID: <58afb242-183b-226b-d8ba-f83374fd2bb5@enterprisedb.com> Date: Fri, 4 Feb 2022 04:00:21 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.5.0 Subject: Re: Collecting statistics about contents of JSONB columns Content-Language: en-US From: Tomas Vondra To: Mahendra Singh Thalor Cc: Nikita Glukhov , PostgreSQL Hackers , Mahendra Thalor , Oleg Bartunov , Thomas Munro References: <15d637bb-900e-e67b-361b-d70a79c324d7@enterprisedb.com> In-Reply-To: <15d637bb-900e-e67b-361b-d70a79c324d7@enterprisedb.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2/4/22 03:47, Tomas Vondra wrote: > ./json-generate.py 30000 2 8 1000 6 1000 Sorry, this should be (different order of parameters): ./json-generate.py 30000 2 1000 8 6 1000 regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company