# Executions\_visibility does not exist **URL:** \ **Category:** Community Support\ **Created:** [October 10, 2022, 7:39am UTC](https://community.temporal.io/t/executions-visibility-does-not-exist/6166 "2022-10-10T07:39:53Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![knk\_101](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/knk_101/32/2598_2.png) [@knk\_101](https://community.temporal.io/u/knk_101)\ **Post date:** [October 10, 2022, 7:39am UTC](https://community.temporal.io/t/executions-visibility-does-not-exist/6166/1 "2022-10-10T07:39:53Z")
when trying to browse the workflow through the admin portal, getting error : > ListOpenWorkflowExecutions operation failed. Select failed: pq: relation “executions\_visibility” does not exist any advice on what could be missing? We are using postgress DB. ![execution_visiblity_error](https://us1.discourse-cdn.com/flex016/uploads/temporal/original/2X/3/32dc9d66aa66a6da6365d65d3393f1706d9bb84b.jpeg) ---
**Author:** ![antonio.perez](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/antonio.perez/32/2417_2.png) [@antonio.perez](https://community.temporal.io/u/antonio.perez)\ **Post date:** [October 10, 2022, 10:24am UTC](https://community.temporal.io/t/executions-visibility-does-not-exist/6166/3 "2022-10-10T10:24:30Z")
Hello @knk_101 The ListWorkflow API hits the visibility DB (temporal\_visibility) to query the workflows. It looks like your visibility DB does not have the right structure. How are you setting up the Temporal server and the database? ---
**Author:** ![knk\_101](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/knk_101/32/2598_2.png) [@knk\_101](https://community.temporal.io/u/knk_101)\ **Post date:** [October 10, 2022, 3:13pm UTC](https://community.temporal.io/t/executions-visibility-does-not-exist/6166/4 "2022-10-10T15:13:43Z")
Tables in temporal\_visibility DB were not created correctly. Now it is working fine. Thanks