Skip to content

Add filter to exclude non internal users in REST API

Francisco Javier López (ex-Gitlab) requested to merge 241144-fj-add-non-internal-filter-to-users-rest-endpoint into master

What does this MR do?

In this MR we add the exclude_internal filter to the /users endpoint to allow returning only non-internal users.

Query and plan with just this new param

SELECT
    "users".*
FROM
    "users"
WHERE ("users"."user_type" IS NULL
    OR "users"."user_type" IN (NULL, 6, 4))
ORDER BY
    "users"."id" DESC

Plan: https://explain.depesz.com/s/WJZ2

Time: 9.789 s
  - planning: 0.445 ms
  - execution: 9.789 s
    - I/O read: 1.583 s
    - I/O write: 0.000 ms

Shared buffers:
  - hits: 259961 (~2.00 GiB) from the buffer pool
  - reads: 128006 (~1000.00 MiB) from the OS file cache, including disk I/O
  - dirtied: 0
  - writes: 0

Refs #241144 (closed)

Does this MR meet the acceptance criteria?

Conformity

Edited by Francisco Javier López (ex-Gitlab)

Merge request reports