On Tue, 2025-07-15 at 15:40 +0530, Durgamahesh Manne wrote:
> We are facing issues with slow running query
> SELECT betid, versionid, betdata, processed, messagetime, createdat, updatedat
> FROM praermabetdata where processed = 'false'
> ORDER BY betid, versionid LIMIT 200 OFFSET 0 FOR UPDATE;
>
> QUERY PLAN
>
--------------------------------------------------------------------------------------------------------------------------------
> Limit (cost=0.28..1.89 rows=1 width=78)
> -> LockRows (cost=0.28..1.89 rows=1 width=78)
> -> Index Scan using idx_praermabetdata_processed_betid_versionid on praermabetdata (cost=0.28..1.88 rows=1
width=78)
> Index Cond: (processed = false)
>
> image.png
>
> Do we have any alternative way to improve the performance?
> Sometimes processed column use true as well as false
Please provide EXPLAIN (ANALYZE, BUFFERS) output and use "log_lock_waits"
to see if you are hanging behind locks for a longer time.
Yours,
Laurenz Albe
