SET trace_sort=true; SET client_min_messages=log; SET log_temp_files=0; explain ANALYZE SELECT processo0_.id_processo AS id1_488_0_, processo0_.nm_actor_id AS nm2_488_0_, processo0_.id_caixa AS id11_488_0_, processo0_.ds_complemento AS ds3_488_0_, processo0_.dt_fim AS dt4_488_0_, processo0_.dt_inicio AS dt5_488_0_, processo0_.nr_duracao AS nr6_488_0_, processo0_.id_fluxo AS id12_488_0_, processo0_.id_jbpm AS id7_488_0_, processo0_.ds_nm_usu_cadastro_processo AS ds8_488_0_, processo0_.nr_processo AS nr9_488_0_, processo0_.nr_processo_origem AS nr10_488_0_, processo0_.id_status AS id13_488_0_, processo0_.id_usuario_cadastro_processo AS id14_488_0_ FROM tb_processo processo0_ WHERE processo0_.id_processo = 999;
"Index Scan using sys_c005762 on tb_processo processo0_ (cost=0.42..8.44 rows=1 width=183) (actual time=0.020..0.021 rows=1 loops=1)" " Index Cond: ((id_processo)::integer = 999)" "Total runtime: 0.048 ms" work_mem 30MB
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
