d = c.relnamespace
LEFT JOIN pg_catalog.pg_am am ON am.oid = c.relam
WHERE c.relkind IN ('r','p','')
AND n.nspname <> 'pg_catalog'
AND n.nspname !~ '^pg_toast'
AND n.nspname <> 'information_schema'
AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1,2;
/Nicklas Avén
On 4 December 2020 17:17:48 CET, Adrian Klaver
wrote:
>On 12/4/20 8:03 AM, Paul Förster wrote:
>> Hi Adrian,
>>
>>> On 04. Dec, 2020, at 16:13, Adrian Klaver
> wrote:
>>> That is the wrong file, the *.sample is the giveaway.
>>
>> hmmm, I'd rather call it essential reference documentation or
To find out if there is some locking problem or just takes time for the
client to handle the data, ask just for a small subset of the table.
If
select * from table limit 1;
works it is probably just taking a lot of time to send all the data to
the client.
If the data set includes something
ed to
determine a cloud environment.
-Rashmi
-"Nicklas Avén" <mailto:nicklas.a...@jordogskog.no>> wrote: -
To: Rashmi V Bharadwaj mailto:rvbha...@in.ibm.com>>
From: "Nicklas Avén" <mailto:nicklas.a...@jordogskog.no>>
Date: 07/05/2019 12:46PM
Subject:
On 16 February 2019 06:02:50 GMT+01:00, Tom Lane wrote:
>=?UTF-8?Q?Nicklas_Av=c3=a9n?= writes:
>> I also, in the first query, changed the where clause to filter on
>> machine_key in table contractor _access. Just to illustrate the
>problem
>> better.
>
>> Both queries filter on the same table
> I have not had chance to fully go through all of below. Some
questions/suggestions:
>
> 1) Thanks for the formatted queries. If I could make a suggestion,
when aliasing could you include AS. It would make finding what l.*
refers to easier for those of us with old eyes:)
>
Yes, of course,
On 2/15/19 5:06 PM, Adrian Klaver wrote:
> On 2/15/19 7:28 AM, Nicklas Avén wrote:
>> Hi
>>
>> The problem is that it always calculates all those 22000 rows even
if the user id I use only gives 250 rows.
>>
>> So, the query uses 4 seconds i
s=455 width=31)
-> Hash (cost=7.59..7.59 rows=4 width=21)
-> Seq Scan on contractor_access (cost=0.00..7.59
rows=4 width=21)
Filter: (t4e_contractor_id =
'name@email.address'::text)
Thanks
Nicklas Avén
