Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Improve execution plan for "get_job_log_entries"

RCA Group

None

Description

WARN PostgresClient [51768966eqId] EXPLAIN ANALYZE SELECT * FROM get_job_log_entries('bcc3699c-3ab6-4c99-85f4-766a0dedaac0', 'instance_action_status', 'ASC', 100, 0)
Function Scan on get_job_log_entries (cost=0.25..10.25 rows=1000 width=476) (actual time=1375.856..1375.864 rows=100 loops=1)
Planning Time: 0.033 ms
Execution Time: 1375.887 ms

WARN PostgresClient [50483603eqId] EXPLAIN ANALYZE SELECT * FROM get_job_log_entries('bcc3699c-3ab6-4c99-85f4-766a0dedaac0', 'source_record_order', 'ASC', 100, 0)
Function Scan on get_job_log_entries (cost=0.25..10.25 rows=1000 width=476) (actual time=1423.660..1423.668 rows=100 loops=1)
Planning Time: 0.037 ms
Execution Time: 1423.693 ms

WARN PostgresClient [50512314eqId] EXPLAIN ANALYZE SELECT * FROM get_job_log_entries('bcc3699c-3ab6-4c99-85f4-766a0dedaac0', 'error', 'ASC', 100, 0)
Function Scan on get_job_log_entries (cost=0.25..10.25 rows=1000 width=476) (actual time=1436.900..1436.908 rows=100 loops=1)
Planning Time: 0.037 ms
Execution Time: 1436.934 ms
 

Environment

None

Potential Workaround

None

Attachments

1

Checklist

hide

TestRail: Results

Activity

Show:

Ann-Marie Breaux March 13, 2023 at 6:51 AM

P3 issue; moving to Release "Not scheduled" to decrease scope

Ann-Marie Breaux January 30, 2023 at 7:01 PM

Moved from Orchid to Poppy to decrease scope

Kateryna Senchenko June 8, 2022 at 11:53 AM

It would be nice to address it in MG, but it is not that critical to block the release

Details

Assignee

Reporter

Labels

Priority

Story Points

Development Team

Folijet

Parent

Release

Not Scheduled

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created May 25, 2022 at 9:16 AM
Updated March 13, 2023 at 6:51 AM
TestRail: Cases
TestRail: Runs