Created
May 23, 2012 18:43
-
-
Save vinnix/2777007 to your computer and use it in GitHub Desktop.
Resultado de execução da rotina de testes JDBC vinnix/JavaLab/Scrollable.java
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment