On Wed, Dec 27, 2023 at 2:23 PM Ranier Vilela wrote:
> ...
>
> Although granule_file has an index as a foreign key, it seems to me that
> it is not being considered.
>
You seem to be mistaken here, a foreign key does not automatically create
an index on the columns, you need to do it by
On Wed, Dec 27, 2023 at 2:11 PM Wilson, Maria Louise (LARC-E301)[RSES] <
m.l.wil...@nasa.gov> wrote:
> Thanks for the reply!! Having some issues due to nulls…. Any other
> thoughts?
>
>
>
> i=# ALTER TABLE granule_file ADD PRIMARY KEY (granule_uuid, file_id);
>
> ERROR: column "granule_uuid"
Here is the before analyze :
Sort (cost=3208325.03..3208325.33 rows=117 width=997) (actual
time=56683.259..56683.307 rows=4 loops=1)
Sort Key: granule.uuid
Sort Method: quicksort Memory: 32kB
Buffers: shared hit=40 read=795724, temp read=630171 written=630171
-> Hash Left
Em qua., 27 de dez. de 2023 às 14:11, Wilson, Maria Louise
(LARC-E301)[RSES] escreveu:
> Thanks for the reply!! Having some issues due to nulls…. Any other
> thoughts?
>
>
>
> i=# ALTER TABLE granule_file ADD PRIMARY KEY (granule_uuid, file_id);
>
> ERROR: column "granule_uuid" contains null
Thanks for the reply!! Having some issues due to nulls…. Any other thoughts?
i=# ALTER TABLE granule_file ADD PRIMARY KEY (granule_uuid, file_id);
ERROR: column "granule_uuid" contains null values
From: Matheus de Oliveira
Date: Wednesday, December 27, 2023 at 11:36 AM
To: "Wilson, Maria
>
>-> Hash Join (cost=644250.54..10734700.30 rows=22333224
> width=223) (actual time=7864.023..44546.392 rows=22325462 loops=1)
> Hash Cond: (file_1.id = granule_file_1.file_id)
> Buffers: shared hit=780882 read=8345236
>
Hi Maria, could you please run explain analyse for the problem query?
The ‘analyze’ addition will track actual spent time and show statistics to
validate the planner’s assumptions.
Frits Hoogland
> On 27 Dec 2023, at 16:38, Wilson, Maria Louise (LARC-E301)[RSES]
> wrote:
>
> Hello folks!
Hello folks!
I am having a complex query slowing over time increasing in duration. If
anyone has a few cycles that they could lend a hand or just point me in the
right direction with this – I would surely appreciate it! Fairly beefy Linux
server with Postgres 12 (latest) – this particular
On Wed, Dec 27, 2023 at 8:15 AM mohini mane
wrote:
> Hello Team,
> I observed that increasing the degree of parallel hint in the SELECT
> query did not show performance improvements.
> Below are the details of sample execution with EXPLAIN ANALYZE
>
PostgreSQL doesn't have hints, unless you are
On 12/27/23 14:15, mohini mane wrote:
> Hello Team,
> I observed that increasing the degree of parallel hint* *in the SELECT
> query did not show performance improvements.
> Below are the details of sample execution with EXPLAIN ANALYZE
> *PostgreSQL Version:* v15.5
>
> *Operating System
Hello Team,
I observed that increasing the degree of parallel hint in the SELECT query
did not show performance improvements.
Below are the details of sample execution with EXPLAIN ANALYZE
*PostgreSQL Version:* v15.5
*Operating System details:* RHL 7.x
Architecture: x86_64
CPU
11 matches
Mail list logo