Table with Composite Primary Key Not Using Primary Key Index

[batu-inal]

have a table with the composite key of <type, org_id>; when i query the table using hasura using the following:

query MyQuery {
  account_by_pk(org_id: "92bc2bb1-4f2f-445d-902c-6dd5a9b6952f", type: "CREDIT"){
    org_id
  }
}

or

query MyQuery {
  account(where: {
    _and: [
      {type: {_eq: "CREDIT"}},
      {org_id: {_eq: "92bc2bb1-4f2f-445d-902c-6dd5a9b6952f"}}
    ]
  }) {
    org_id
  }
}

it doesnt use the primary key index, does anyone know how to resolve this issue? Thanks so much.

The generated sql is:

SELECT
  coalesce((json_agg("root") -> 0), 'null') AS "root"
FROM
  (
    SELECT
      row_to_json(
        (
          SELECT
            "_e"
          FROM
            (
              SELECT
                "_root.base"."org_id" AS "org_id"
            ) AS "_e"
        )
      ) AS "root"
    FROM
      (
        SELECT
          *
        FROM
          "public"."account"
        WHERE
          (
            (
              ("public"."account"."type") = (('CREDIT') :: "account_accounttype_enum")
            )
            AND (
              ("public"."account"."org_id") = (('92bc2bb1-4f2f-445d-902c-6dd5a9b6952f') :: uuid)
            )
          )
      ) AS "_root.base"
  ) AS "_root"

with the following execution plan:

Aggregate  (cost=4.04..4.04 rows=1 width=32)
  ->  Index Scan using ix_account_type on account  (cost=0.03..4.03 rows=1 width=16)
        Index Cond: (type = 'CREDIT'::account_accounttype_enum)
        Filter: (org_id = '92bc2bb1-4f2f-445d-902c-6dd5a9b6952f'::uuid)
  SubPlan 1
    ->  Result  (cost=0.00..0.00 rows=1 width=32)