Postgres Query running slow, using pgcrypto externsion in psotgres sql

0

using pgcrypto externsion in psotgres sql, following is the output for below queryies

Query 1:

explain analyze (select * from table_name);  

above query taking time around 900 ms

but when i am using query with 'pgp_sym_decrypt' it taking longer time around 54 sec, that is too high

Encrypted column is indexed


explain analyze (select
	pgp_sym_decrypt("table_name"."sender_contact_person_name",
	'encryption_key')::text,
	pgp_sym_decrypt("table_name"."sender_contact_person_email", 'encryption_key')::text,
	pgp_sym_decrypt("table_name"."sender_contact_person_contact_no",
	'encryption_key')::text,
	pgp_sym_decrypt("table_name"."recipient_contact_person_name",
	'encryption_key')::text,
	pgp_sym_decrypt("table_name"."recipient_contact_person_email",
	'encryption_key')::text,
	pgp_sym_decrypt("table_name"."recipient_contact_person_contact_no",
	'encryption_key')::text,
from
	"table_name"
where
	"table_name"."is_active"
order by
	"table_name"."pickup_date_time"
limit 10)
shiv
feita há 8 meses95 visualizações
Sem respostas

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas