postgers ckb 简单查询 index

 

select count(*) from cell_outputs;
select id,tx_hash,cell_index,capacity from cell_outputs where id = 59153523 limit 1;
select id,tx_hash,cell_index,capacity from cell_outputs where tx_hash = decode('8df812321b057cd3348927c5296dabb859e1ff9b00fcd0e92b57d6bf22c626dc', 'hex')  limit 1;
select id,tx_hash,cell_index,capacity from cell_outputs where tx_hash = decode('8df812321b057cd3348927c5296dabb859e1ff9b00fcd0e92b57d6bf22c626dc', 'hex') and cell_index = 2 limit 1;
explain analyze verbose select id,tx_hash,cell_index,capacity from cell_outputs where tx_hash = decode('8df812321b057cd3348927c5296dabb859e1ff9b00fcd0e92b57d6bf22c626dc', 'hex') and cell_index = 2 limit 1;