On Fri, Dec 29, 2023 at 10:25 AM Jeff Janes wrote:
>
>
> On Thu, Dec 28, 2023 at 7:47 AM mohini mane
> wrote:
>
>> Thank you for your response !!
>> I am experimenting with SQL query performance for SELECT queries on large
>> tables and I observed that changing/increasing the degree of parallel
On Tue, Jan 2, 2024 at 8:12 AM mohini mane wrote:
>
> I have executed the SELECT query with 2,4 & 6 parallel degree however
>>> every time only 4 workers launched & there was a slight increase in
>>> Execution time as well,
>>>
>>
>> Adding an ignored comment to your SQL would not be expected to
On Tue, 2 Jan 2024, 21:45 David G. Johnston,
wrote:
> On Tue, Jan 2, 2024 at 8:12 AM mohini mane
> wrote:
>
>>
>> I have executed the SELECT query with 2,4 & 6 parallel degree however
every time only 4 workers launched & there was a slight increase in
Execution time as well,
>>>
>
We are currently on 13.9. For each of the questions, I'd also like to know
if anything has changed in that area in later releases.
NOTE: We are capturing all explain plans via auto_explain and storing them
in a database table. One of our longer term goals is to build the
relationship between quer
On Tue, Jan 2, 2024 at 1:29 PM Jerry Brenner wrote:
> We are currently on 13.9.
>
Why not just use the latest minor release, 13.13? For security reasons,
that is the only minor release of v13 you should be using anyway. I think
it is a bit much to hope that people will spend their time for fre
Jeff Janes writes:
> On Tue, Jan 2, 2024 at 1:29 PM Jerry Brenner wrote:
>> - It looks like "Output" includes more than just the columns with
>> predicates and/or being accessed or returned in other nodes.
> Not in my hands. For SELECTs it just lists the columns that are needed.
It depends. Th
Tom - Thanks for the response. I guess what I am really looking for is a
simple way to find all of the columns referenced from a given instance of a
table or index from the json file, although it would be even better if it
was easy to differentiate between the columns that came from the index vs
t
