On Tue, Sep 10, 2024 at 4:49 PM Fabrice Chapuis <fabrice636861(at)gmail(dot)com>
wrote:
> no lock, in view pg_stat_activity
>
> status = active
> wait event = NULL
> wait event type = NULL
>
> On Mon, Sep 9, 2024 at 5:00 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> Fabrice Chapuis <fabrice636861(at)gmail(dot)com> writes:
>> > why this update does not return instantly?
>>
>> > UPDATE table_a a
>> > SET col1 = (SELECT MIN(b.col1)
>> > FROM table_b b
>> > WHERE b.col2 = a.col2)
>>
>> Maybe query is waiting for a lock on one of those tables?
>>
>> regards, tom lane
>>
>