Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vzk7H-001Gzv-2y for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Mar 2026 23:34:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vzk6G-0018SV-0E for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Mar 2026 23:33:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vzk6F-0018SM-29 for pgsql-hackers@lists.postgresql.org; Mon, 09 Mar 2026 23:33:24 +0000 Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vzk6E-00000001Ml6-0fAe for pgsql-hackers@postgresql.org; Mon, 09 Mar 2026 23:33:22 +0000 Received: by mail-ej1-x62e.google.com with SMTP id a640c23a62f3a-b966a7b1908so323395066b.1 for ; Mon, 09 Mar 2026 16:33:22 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773099199; cv=none; d=google.com; s=arc-20240605; b=FmOMpl6Ur0Wo1kH75gY+dcm7wM/gucFefJpWvS+/R4xzOxSNME/T/tkIkcqxdmQT+u i7plEJLqtaIGoYwKxZOkk2BeIQOSmeXZ9ESIRDuBfFKSWYA3YFZwo9BJEKtlAvBR7o0e jFBnlX+8Pcwaik6wY56GUknMKq5tFscewJWWn6mtiICjGn59q4mRG6D3GgKF/SERrePK 7FdXDwSoUzOWP9fNuw6/JaEdZFDFxFcnKkWTFmszkvZbCq3cm6cu6z5n61J7ZGVyzREx z8za02EfE4WoxpzVzLlIsms70GZ/VbqRJ26acGjap8IBV3N1GiJ8ueqUoiU5JHLsVrZ8 w8fw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=X8//7E5m+SB5zTWjJ42SBLWGQj+C4N0Sl1DCvn9zrMA=; fh=KugoCGVAO46DqKRaC9C8rns94DMXQD8D0JpzLt2O1QY=; b=UWIHY2B8IGUuH7LF4PAxh+mtukzAag+m7F03XQleyIHknoPmL9TZVtuLLcz+d6qje8 kCxh/xL7BKvlyCWl+gEqxAKcKdDdCvyuMr/34err4PnsJ39AZGJL6lqfVYWIYdAJNmqD 8RgCPmzAdTiJyLsg0uWK22BaIxmAtKBcCQy68yGI1+OBPzc+GXgphoonlwhehi02PjwA 24YR2/TX9VnVEh/3mzRQRV2wbJKYD3cNXHIfWCKUU7HroG1rR8qUyTrNrN5S7N2I9PFT YXQmyHK2CumiBP7nVl/7k7N9/3w1c8e0ytOwHQ3utr42fzCGxjFtKNMQlKgS+H+M0FDH +kuQ==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773099199; x=1773703999; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=X8//7E5m+SB5zTWjJ42SBLWGQj+C4N0Sl1DCvn9zrMA=; b=S40096E/qU+CekXiVXQ2p+FzcKHYpThdXfcPorsZ1PHKe6rRvYNgq+8aAs7HuiK+UU BtwhNRwlzatIXysHLlfi0Bbq6/xUrzgKkdQ0rUSfyjZe/dnG22ALTnMKbatpRZoSblWq RCFwwtxLrn6/EO2Vx5nrZ9nzaFAIBuquj0jgAQhF6Zd3xdNw8QSt5FKBDQsh3HM1elD1 l8XNlI1/fcYEaQ2mRWwA2o/zKZi0UCanjpLLu6HouXQeVGcW9YwW8PZnS19rOVBFjt8s 8rddGb9dIndjy1dvFxFjiFP81bHbOWQaeclaUXYUNM2MYSXpseCoUIOmXgC7HCqIkptW TEfg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1773099199; x=1773703999; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=X8//7E5m+SB5zTWjJ42SBLWGQj+C4N0Sl1DCvn9zrMA=; b=r3IsZxIUXrvPbkY+BRccUubsZhGng3mz53oMEEXm1eq27Wc1WA6QxRBOiDoHWaoJ9Y 60K1gVvvgogBzLxsImHBBZ1DjjKPfhwSNZstJgu5Ps3vW2Hd96Fkk/PPgVTp1QgH7Bf8 azmwJqQqyY61ZUrktv6+5jw8F8pPLoxcfeiXtCfx4i8Tdx7ahawfonl5dklMyEsEqYhU /Pjy8fP6SHmsm76rZfFa/OgI+wHmpaR5lNUTGQD3GeNugDyBv+doYWgGL4wuP9gWxSI+ o1s8dokWXCTW92wsch32octzTzIwpn65bPQfbbBEQWxRDn4u+kCccz1DXgCTesxDeyxg L+5w== X-Gm-Message-State: AOJu0YwIH8Xlvpfo3LmjNRF0VKZrvxQWpV9ZHiakL3tdYqhqVFkI7H7U 59n004KjzucJJw8/gae5MPqOdk9hgVF7aFSYl7/EoyYe8RtOA5v+sHid078X2UjtdgogU5Li3zc dY4cVF0XMl5WANZ0pqKAla6aZP9IrdJS3uR+Vo4A= X-Gm-Gg: ATEYQzxzL+cZfxsXEFBPqVEIEmO+T1Y2EfwtpA4wl1eer9XnK729qkoknU6pK1a6VZr XbvlgLhUyaikIUKL3eLLsdTwVpXZ4aeL4iNprtSbUF2glOVLrtrrZf4j5g9QmnvgTs/vGr+F9FY idWNRikHeSn0MHALxoF1Ilt0/W/Yc4lPAvAdcnXsoB1YwuEWqtbw0EEVsPoD/+ZdPFKTB0hwInx QBFg18OA+WeWR2n2/2wu7k3+4m9lPRjHTRdlRFmXqQ0BzlLAKMq1pgn8S4Mxvocf4g70JO/6ghI YTiI2kvahmzJqx7b X-Received: by 2002:a17:906:9f92:b0:b87:3740:dd87 with SMTP id a640c23a62f3a-b942dceb6d2mr771441266b.26.1773099199010; Mon, 09 Mar 2026 16:33:19 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Sami Imseih Date: Mon, 9 Mar 2026 18:33:08 -0500 X-Gm-Features: AaiRm53gaELPmSA1V2RcywDyokwqD26stGxJQiD1WtVSkc7_hDHEidRQnLAeDKY Message-ID: Subject: Re: Add missing stats_reset column to pg_stat_database_conflicts view To: shihao zhong Cc: PostgreSQL-development Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > The attached patch adds pg_stat_get_db_stat_reset_time() to fix this > inconsistency. > > Please let me know your thoughts. This view was introduced 15 years ago, and surprisingly this is the first complaint about this. I am also not very surprised. I also noticed that pg_statio_all_sequences does not have a reset column. We should fix this one also. What do you think? With regards to your attached patch, it's missing the doc changes. but also the patch does not apply. -- Sami Imseih Amazon Web Services (AWS)