Resultado de execução da rotina de testes JDBC vinnix/JavaLab/Scrollable.java

postgresql_scrollable.log

LOG:  connection received: host=127.0.0.1 port=22948
LOG:  connection authorized: user=pgsql database=postgres
LOG:  duration: 0.124 ms  parse <unnamed>: SET extra_float_digits = 3
LOG:  duration: 0.031 ms  bind <unnamed>: SET extra_float_digits = 3
LOG:  duration: 0.014 ms  execute <unnamed>: SET extra_float_digits = 3
LOG:  duration: 0.991 ms  parse <unnamed>: SELECT * FROM tb_teste a ORDER BY a.col1
LOG:  duration: 0.043 ms  bind <unnamed>: SELECT * FROM tb_teste a ORDER BY a.col1
LOG:  duration: 0.241 ms  execute <unnamed>: SELECT * FROM tb_teste a ORDER BY a.col1
LOG:  duration: 2.889 ms  parse <unnamed>: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM,   ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME,   (i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct   JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid)   JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid)   JOIN (SELECT i.indexrelid, i.indrelid, i.indisprimary,              information_schema._pg_expandarray(i.indkey) AS keys         FROM pg_catalog.pg_index i) i     ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid)   JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE true  AND ct.relname = 'tb_teste' AND i.indisprimary  ORDER BY table_name, pk_name, key_seq
LOG:  duration: 0.356 ms  bind <unnamed>: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM,   ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME,   (i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct   JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid)   JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid)   JOIN (SELECT i.indexrelid, i.indrelid, i.indisprimary,              information_schema._pg_expandarray(i.indkey) AS keys         FROM pg_catalog.pg_index i) i     ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid)   JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE true  AND ct.relname = 'tb_teste' AND i.indisprimary  ORDER BY table_name, pk_name, key_seq
LOG:  duration: 4.660 ms  execute <unnamed>: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM,   ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME,   (i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct   JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid)   JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid)   JOIN (SELECT i.indexrelid, i.indrelid, i.indisprimary,              information_schema._pg_expandarray(i.indkey) AS keys         FROM pg_catalog.pg_index i) i     ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid)   JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE true  AND ct.relname = 'tb_teste' AND i.indisprimary  ORDER BY table_name, pk_name, key_seq
LOG:  duration: 8.534 ms  parse <unnamed>: SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN (SELECT 1511726 AS oid , 1 AS attnum UNION ALL SELECT 1511726, 2) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum)
LOG:  duration: 0.121 ms  bind <unnamed>: SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN (SELECT 1511726 AS oid , 1 AS attnum UNION ALL SELECT 1511726, 2) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum)
LOG:  duration: 0.443 ms  execute <unnamed>: SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN (SELECT 1511726 AS oid , 1 AS attnum UNION ALL SELECT 1511726, 2) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum)
LOG:  duration: 0.398 ms  parse <unnamed>: UPDATE tb_teste SET  "col2" = $1 WHERE "col1" = $2
LOG:  duration: 0.115 ms  bind <unnamed>: UPDATE tb_teste SET  "col2" = $1 WHERE "col1" = $2
DETAIL:  parameters: $1 = 'HelloWorld', $2 = '10'
LOG:  duration: 0.063 ms  execute <unnamed>: UPDATE tb_teste SET  "col2" = $1 WHERE "col1" = $2
DETAIL:  parameters: $1 = 'HelloWorld', $2 = '10'
LOG:  duration: 0.070 ms  parse <unnamed>: SELECT $1
LOG:  duration: 0.037 ms  bind <unnamed>: SELECT $1
DETAIL:  parameters: $1 = '1'
LOG:  duration: 0.008 ms  execute <unnamed>: SELECT $1
DETAIL:  parameters: $1 = '1'
LOG:  duration: 0.063 ms  parse <unnamed>: SELECT $1
LOG:  duration: 0.034 ms  bind <unnamed>: SELECT $1
DETAIL:  parameters: $1 = '2'
LOG:  duration: 0.007 ms  execute <unnamed>: SELECT $1
DETAIL:  parameters: $1 = '2'
LOG:  duration: 0.058 ms  parse S_1: SELECT $1
LOG:  duration: 0.016 ms  bind S_1: SELECT $1
DETAIL:  parameters: $1 = '3'
LOG:  duration: 0.006 ms  execute S_1: SELECT $1
DETAIL:  parameters: $1 = '3'
LOG:  duration: 0.036 ms  bind S_1: SELECT $1
DETAIL:  parameters: $1 = '4'
LOG:  duration: 0.008 ms  execute S_1: SELECT $1
DETAIL:  parameters: $1 = '4'
LOG:  duration: 0.033 ms  bind S_1: SELECT $1
DETAIL:  parameters: $1 = '5'
LOG:  duration: 0.008 ms  execute S_1: SELECT $1
DETAIL:  parameters: $1 = '5'
LOG:  disconnection: session time: 0:00:00.110 user=pgsql database=postgres host=127.0.0.1 port=22948