contrib/pg_stat_statements/expected/extended.out

   1 -- Tests with extended query protocol
   2 SET pg_stat_statements.track_utility = FALSE;
   3 -- This test checks that an execute message sets a query ID.
   4 SELECT query_id IS NOT NULL AS query_id_set
   5   FROM pg_stat_activity WHERE pid = pg_backend_pid() \bind \g
   6  query_id_set
   7 --------------
   8  t
   9 (1 row)
  10
  11 SELECT pg_stat_statements_reset() IS NOT NULL AS t;
  12  t
  13 ---
  14  t
  15 (1 row)
  16
  17 SELECT $1 \parse stmt1
  18 SELECT $1, $2 \parse stmt2
  19 SELECT $1, $2, $3 \parse stmt3
  20 SELECT $1 \bind 'unnamed_val1' \g
  21    ?column?
  22 --------------
  23  unnamed_val1
  24 (1 row)
  25
  26 \bind_named stmt1 'stmt1_val1' \g
  27   ?column?
  28 ------------
  29  stmt1_val1
  30 (1 row)
  31
  32 \bind_named stmt2 'stmt2_val1' 'stmt2_val2' \g
  33   ?column?  |  ?column?
  34 ------------+------------
  35  stmt2_val1 | stmt2_val2
  36 (1 row)
  37
  38 \bind_named stmt3 'stmt3_val1' 'stmt3_val2' 'stmt3_val3' \g
  39   ?column?  |  ?column?  |  ?column?
  40 ------------+------------+------------
  41  stmt3_val1 | stmt3_val2 | stmt3_val3
  42 (1 row)
  43
  44 \bind_named stmt3 'stmt3_val4' 'stmt3_val5' 'stmt3_val6' \g
  45   ?column?  |  ?column?  |  ?column?
  46 ------------+------------+------------
  47  stmt3_val4 | stmt3_val5 | stmt3_val6
  48 (1 row)
  49
  50 \bind_named stmt2 'stmt2_val3' 'stmt2_val4' \g
  51   ?column?  |  ?column?
  52 ------------+------------
  53  stmt2_val3 | stmt2_val4
  54 (1 row)
  55
  56 \bind_named stmt1 'stmt1_val1' \g
  57   ?column?
  58 ------------
  59  stmt1_val1
  60 (1 row)
  61
  62 SELECT calls, rows, query FROM pg_stat_statements ORDER BY query COLLATE "C";
  63  calls | rows |                       query
  64 -------+------+----------------------------------------------------
  65      3 |    3 | SELECT $1
  66      2 |    2 | SELECT $1, $2
  67      2 |    2 | SELECT $1, $2, $3
  68      1 |    1 | SELECT pg_stat_statements_reset() IS NOT NULL AS t
  69 (4 rows)
  70