Problem: Loading task output is slow.

[ShaneMcC]

Issue

Using a postgres database, task output display is slow when there are many tasks with long outputs.

I don't seem to have an index on the task_id column in the task__output table, which I assume is the reason for the slowness.

Manually running:

create index task__output_task_id on task__output (task_id);

On the database seems to have fixed the problem.

Impact

Web-Frontend (what users interact with)

Installation method

Docker

Database

Postgres

Browser

Chrome

Semaphore Version

v2.16.17-5c8e54e-1755415970

Ansible Version

Logs & errors

No response

Manual installation - system information

No response

Configuration

No response

Additional information

No response

[fiftin]

@ShaneMcC wow. Thank you. I will check.

[fiftin]

@ShaneMcC task_id is foreign key, it already has index. I checked for MySQL and Postgres.

[ShaneMcC]

I do not believe that postgres automatically creates indexes on the referencing-side for foreign keys (ie, on the task__output table) and this stack-overflow post confirms the same: https://stackoverflow.com/questions/970562/postgres-and-indexes-on-foreign-keys-and-primary-keys

Where are you seeing otherwise? I certainly didn't have an index for it in my database for my semaphore install