Conseil needs new indices

[leenpaws]

In order to fix the previously slow queries being performed due to sequential scan, new indices need to be added.

the following indices were added to prod2 and a remarkable increase in performance was seen

       	CREATE INDEX ix_manager_pubkey ON tezos.operations USING btree (manager_pubkey);
       	CREATE INDEX ix_operation_group_hash ON tezos.operations USING btree (operation_group_hash);
	CREATE INDEX ix_originated_contracts ON tezos.operations USING btree (originated_contracts);

After the change, the slowest queries were:

pgbadger-output.zip

[leenpaws]

Attached is pgbadger output before and after the addition of the indices, ending in main3.html is before the addition.

[ivanopagano]

Is this ticket done, @leenpaws ?