Question about the workflow execution history

Community Support
1

hello, for past workflow execution i have several questions.

  1. will temporal clean past workflow execution records? using
    select count(*) from executions;
    returns different results and the server seems removed serval past executions?
  2. I find that web ui only shows part of the entire workflow executions. e.g. there are 80 executions in database table but only about 30-40 are shown. (early workflow executions were 3 days ago).
    how can i change the setting to see more workflow executions? I tried
    export TEMPORAL_HISTORY_ARCHIVAL_QUERY_MAX_PAGE_SIZE=1000
    but seems not working.

Thanks.

2

I went through the doc, is this because of the default 3 days Retention Period?

3

for 1) yes this will depend on your namespace retention period set. once an execution completes, and this completed execution hits namespace retention, it is removed from persistence

1 Like
4

I tried
export TEMPORAL_HISTORY_ARCHIVAL_QUERY_MAX_PAGE_SIZE=1000

are you looking at archived executions? trying to fully understand issue.
default page size for visibility records is 1K, ui should iirc show up to 100 records without having to paginate in the ui page

1 Like
5

i set retention for “default” namespace with this command, but it seems not working?
tctl --address ADDR namespace update --retention 30 default

6

that command looks correct to me except the last “default”
should be just

tctl --address ADDR namespace update --retention 30

if namespace is not specified, tctl would use “default”

if you do that check

tctl --address <addrs> namespace desc
7

if you want to explicitly set namespace name, you can do like

tctl --address <addrs> --namespace <nsname> namespace update --retention X

where X is in days