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 <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1vhNOU-00Dqey-2L
	for pgsql-performance@arkaria.postgresql.org;
	Sun, 18 Jan 2026 07:40:19 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1vhNOT-00A9KR-10
	for pgsql-performance@arkaria.postgresql.org;
	Sun, 18 Jan 2026 07:40:17 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <lillian@star-ark.net>)
	id 1vhERV-009iyX-0k
	for pgsql-performance@lists.postgresql.org;
	Sat, 17 Jan 2026 22:06:49 +0000
Received: from fhigh-b3-smtp.messagingengine.com ([202.12.124.154])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <lillian@star-ark.net>)
	id 1vhERS-0013au-2G
	for pgsql-performance@lists.postgresql.org;
	Sat, 17 Jan 2026 22:06:48 +0000
Received: from phl-compute-05.internal (phl-compute-05.internal [10.202.2.45])
	by mailfhigh.stl.internal (Postfix) with ESMTP id 76D107A02C0;
	Sat, 17 Jan 2026 17:06:44 -0500 (EST)
Received: from phl-imap-16 ([10.202.2.88])
  by phl-compute-05.internal (MEProxy); Sat, 17 Jan 2026 17:06:44 -0500
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=star-ark.net; h=
	cc:cc:content-transfer-encoding:content-type:content-type:date
	:date:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to; s=fm2; t=1768687604;
	 x=1768774004; bh=Ro7TMP2Dpf+l2IUC4ZquZkexzVpfTIzip7CJix9OinM=; b=
	RRe+11joaAqRRqGHhXixanhZtz1WD8zUaimr1NVqNxMBUORjCm1rWqZgwGVS8td8
	ljCmPsT/4aFbCMJS1A4Wm59/tCtf2o3E9n3n6BHX9eU2M7Oy2MT1rWFoa3d7VdLW
	InMxdkqqft1FiT9ix+AoFGtTU9Kg+u1hh2QErVLSM2jqBKFkAmsBsk+dev0obxcN
	e0DZM7p2CU8ozxFs511Vk2cSV/ReScxYxytZCUjVBkNBXl62Xp2AEWJoLHWNkvaS
	a5WpH8m2KMY5nxeHdu9JbeRGSWIGNinFKiVOexo7cls5T9jSf3ZaIPI4zKc8zyue
	yLfJl35RJOwlwr+IVz6IUQ==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:cc:content-transfer-encoding
	:content-type:content-type:date:date:feedback-id:feedback-id
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1768687604; x=
	1768774004; bh=Ro7TMP2Dpf+l2IUC4ZquZkexzVpfTIzip7CJix9OinM=; b=X
	SnkKMU68NeUMAQGxwY1K96wJYJVabQvYUbuahO2TpEVt1nLh9o+JIzTTcirIUI7e
	0Xtj3p6XN4cCMK//tB9a+onsGPkI/ccTMT5ToesIRV2w6HACZGbvlQxmiwEN67cU
	Wtn4EcrJ42SzWUtgzdt5BS2n3UdfEEh8UyYvsArZaD0BISW4wtfMaIzPyRbMfxtI
	s/68jZlBLZa9EztLCQt7sti98RDNX+aiWOOOwDuLrFk6hkZUzkhWOdmEuCZeAkrW
	pjxfe4P80o19wYgreBx1HLccUb23tqCcgWDD0pRkDLcQ1qorLdYalUFSQYTFJi/S
	iirqF7r4kYE0zmHUNX/dw==
X-ME-Sender: <xms:9Adsae0bMykP6QRP-DfmtZ5oDJhyaD1Tmxm2Dz_JXYWtB7RMy8_R1g>
    <xme:9Adsab6l5JX5BtjZRMfXzgA8hLl6OgU8hdwTxCTdSSx6yjEYXyOkipCiU9z0zTEEQ
    sV3Yq4U7xzTLpyJOAlCBZbXMxK8svjeB_Q5t4ueoN8GGGeuryKfeA>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgddufedvleejucetufdoteggodetrf
    dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu
    rghilhhouhhtmecufedttdenucenucfjughrpefoggffhffvvefkjghfufgtgfesthejre
    dtredttdenucfhrhhomhepfdfnihhllhhirghnuceuvghrrhihfdcuoehlihhllhhirghn
    sehsthgrrhdqrghrkhdrnhgvtheqnecuggftrfgrthhtvghrnhepgfdtgeegtdehfeefke
    fgfeffieekfedvtdeiudffvdevudekvdfhheekfefhfffhnecuvehluhhsthgvrhfuihii
    vgeptdenucfrrghrrghmpehmrghilhhfrhhomheplhhilhhlihgrnhesshhtrghrqdgrrh
    hkrdhnvghtpdhnsggprhgtphhtthhopeegpdhmohguvgepshhmthhpohhuthdprhgtphht
    thhopehlvghpihhhohhvsehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqph
    gvrhhfohhrmhgrnhgtvgeslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhgpdhrtghp
    thhtohepihhnfhhrrgesphhluhhrrghlkhhithdrmhgvpdhrtghpthhtohepthhglhessh
    hsshdrphhghhdrphgrrdhush
X-ME-Proxy: <xmx:9AdsaQixoJzGAomlQxhDMyQshdc6hE-bFs3LBZrD2MkWOMBa9vV1yQ>
    <xmx:9Adsaf52BU7JJ0SwVXew-3UC_SLRXXyG3a2JlWO17KHtm6Yx5BvNEw>
    <xmx:9AdsaQZxdrqR10sRWG4nhQoVsxGJ6Y2kdBAFtCKj1AmwLvkJlFB9Yg>
    <xmx:9Adsac6tIrkIyP3vw755K1aqXW5uuPkV6kJnul0II79oNrC05feKcg>
    <xmx:9AdsaRbRxZCWMwGpcRDruLuX3x7k97jPx22ijK3blzEPiAxpe5tj9UpP>
Feedback-ID: i8db94900:Fastmail
Received: by mailuser.phl.internal (Postfix, from userid 501)
	id 118F12CC0083; Sat, 17 Jan 2026 17:06:44 -0500 (EST)
X-Mailer: MessagingEngine.com Webmail Interface
MIME-Version: 1.0
X-ThreadId: AuzG0eDhvpdc
Date: Sat, 17 Jan 2026 23:06:39 +0100
From: "Lillian Berry" <lillian@star-ark.net>
To: "Tom Lane" <tgl@sss.pgh.pa.us>, "Andrei Lepikhov" <lepihov@gmail.com>
Cc: pgsql-performance@lists.postgresql.org, infra@pluralkit.me
Message-Id: <bf946593-213d-4fb2-8f67-d10827b0605b@app.fastmail.com>
In-Reply-To: <77030.1768684245@sss.pgh.pa.us>
References: <aaf503fd-c08c-465d-9d80-4a71abb722c1@app.fastmail.com>
 <1d79d974-acfe-483c-81da-61989ed2f91b@gmail.com>
 <77030.1768684245@sss.pgh.pa.us>
Subject: [Solved] Slow queries on simple index
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Archived-At: 
 <https://www.postgresql.org/message-id/bf946593-213d-4fb2-8f67-d10827b0605b%40app.fastmail.com>
Precedence: bulk

> I bet it's a datatype mismatch issue.

It was indeed!

I changed the query to `select * from members where hid = ($1)::char(6)` and this completely got rid of the slow queries.

Thanks all!

Kindly,
Lillian