postgres is not closing the connection after the transaction

[ashokthangaraj]

Hi,

i observed there are queries which are in idle state even after the transaction is completed.The query went to idle state with waiting for ClientRead. Kindly help to fix it.

sample query with idle state:

3194297 | postgres | 2023-10-12 01:53:38.010808+00 | 00:11:11.509533 | SELECT DISTINCT "extras_tag"."name", "extras_tag"."slug", "extras_tag"."created", "extras_tag"."last_updated", "extras_tag"."id", "extras_tag"."color", "extras_tag"."description", COUNT("extras_taggeditem"."id") AS "count" FROM "extras_tag" INNER JOIN "extras_taggeditem" ON ("extras_tag"."id" = "extras_taggeditem"."tag_id") INNER JOIN "django_content_type" ON ("extras_taggeditem"."content_type_id" = "django_content_type"."id") WHERE ("django_content_type"."app_label" = 'ipam' AND "django_content_type"."model" = 'aggregate') GROUP BY "extras_tag"."id" ORDER BY "extras_tag"."name" ASC | idle | Client | ClientRead
3194299 | postgres | 2023-10-12 01:58:01.418213+00 | 00:06:48.102128 | SELECT DISTINCT "extras_tag"."name", "extras_tag"."slug", "extras_tag"."created", "extras_tag"."last_updated", "extras_tag"."id", "extras_tag"."color", "extras_tag"."description", COUNT("extras_taggeditem"."id") AS "count" FROM "extras_tag" INNER JOIN "extras_taggeditem" ON ("extras_tag"."id" = "extras_taggeditem"."tag_id") INNER JOIN "django_content_type" ON ("extras_taggeditem"."content_type_id" = "django_content_type"."id") WHERE ("django_content_type"."app_label" = 'dcim' AND "django_content_type"."model" = 'cable') GROUP BY "extras_tag"."id" ORDER BY "extras_tag"."name" ASC | idle | Client | ClientRead
3195249 | postgres | 2023-10-12 01:57:49.487161+00 | 00:07:00.03318 | SELECT DISTINCT "extras_tag"."name", "extras_tag"."slug", "extras_tag"."created", "extras_tag"."last_updated", "extras_tag"."id", "extras_tag"."color", "extras_tag"."description", COUNT("extras_taggeditem"."id") AS "count" FROM "extras_tag" INNER JOIN "extras_taggeditem" ON ("extras_tag"."id" = "extras_taggeditem"."tag_id") INNER JOIN "django_content_type" ON ("extras_taggeditem"."content_type_id" = "django_content_type"."id") WHERE ("django_content_type"."app_label" = 'ipam' AND "django_content_type"."model" = 'ipaddress') GROUP BY "extras_tag"."id" ORDER BY "extras_tag"."name" ASC | idle | Client | ClientRead