PostgreSQL real time count

I’m sorry, I got confused significantly.

I have the extremely simple PostgreSQL orders table with the following columns:
order_id, last_update_timestamp, status, type.

Is it possible to construct a dashboard to see in real time the number of orders satisfying a simple request:
select count(order_id) as order_count
from orders
where status = ‘myStatus’
and type = ‘myType’
?

Thank you a lot for your help.