Hi,
Is there a way to visualize RLS policy check(s) in the query plan?
Regards,
Akash Anand
On Mon, Jul 10, 2023 at 11:33 AM Akash Anand wrote:
> Hi,
>
> --
> Postgres version
> --
> postgres=# SELECT version();
>
3 rows=102863 width=15) (actual time=0.008..0.009
rows=14 loops=1)
Index Cond: ("AlbumId" = "Album"."AlbumId")
SubPlan 2
-> Result (cost=0.00..0.01 rows=1 width=32) (actual
time=0.000..0.000 rows=1 loops=14)
SubPlan 1
-> Result (cost=0.00..0.01 rows=1 width=32) (actual
time=0.000..0.000 rows=1 loops=1)
Planning Time: 0.182 ms
Execution Time: 0.094 ms
(18 rows)
--
Why did Postgres choose to do a sequential scan on Track when RLS is
enabled?
Regards,
Akash Anand