Which psql commands are issued to delete datastore entries.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The package PCK.AUTOMIC_ANALYTICS provides a psql script to vacuum the PostgreSQL database.

The workflow PCK.AUTOMIC_ANALYTICS.PUB.ACTION.DATASTORE_DELETE includes a job that deletes (vacuums) objects from the PostgreSQL database.

Which psql commands are issued?

Environment

Release : 12.3

Component : ANALYTICS ON PREMISE

Cause

Question.

Resolution

The following psql commands are issued from command line.

psql -t -A -h localhost -p 5434 -U analytics -d analytics -c "select * from analytics_datastore_delete_before('2020-07-01 15:16:19.0+00');
psql -t -A -h localhost -p 5434 -U analytics -d analytics -c "select * from analytics_datastore_staging_delete_before('2020-07-01 15:16:19.0+00');
psql -t -A -h localhost -p 5434 -U analytics -d analytics -c "VACUUM FULL VERBOSE;"