Skip to content

Instantly share code, notes, and snippets.

@jberkus

jberkus/gist:1f286e0ec70f19fbb92c

Created October 17, 2014 17:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jberkus/1f286e0ec70f19fbb92c to your computer and use it in GitHub Desktop.
Save jberkus/1f286e0ec70f19fbb92c to your computer and use it in GitHub Desktop.
Download ZIP
JSON test for pgbadger
Raw
gistfile1.txt
2014-10-14 18:28:49.330 UTC,"postgres","postgres",30471,"[local]",543d6b47.7707,1,"CREATE TABLE",2014-10-14 18:28:23 UTC,1/0,0,LOG,00000,"duration: 35.077 ms statement: create table jsontest ( id serial, somejson jsonb );",,,,,,,,,"psql"
2014-10-14 18:33:37.956 UTC,"postgres","postgres",30471,"[local]",543d6b47.7707,2,"INSERT",2014-10-14 18:28:23 UTC,1/9,0,ERROR,22P02,"invalid input syntax for type json","Token ""="" is invalid.",,,,"JSON data, line 1: { ""doc"" =...","insert into jsontest ( somejson ) values ( '{ ""doc"" = ""af42342e6"", ""content"": ""there''s """"something"""" I want to tell you"" }' );",44,,"psql"
2014-10-14 18:33:56.307 UTC,"postgres","postgres",30471,"[local]",543d6b47.7707,3,"INSERT",2014-10-14 18:28:23 UTC,1/10,0,ERROR,22P02,"invalid input syntax for type json","Expected "","" or ""}"", but found """"something"""".",,,,"JSON data, line 1: ..."" : ""af42342e6"", ""content"": ""there's """"something""...","insert into jsontest ( somejson ) values ( '{ ""doc"" : ""af42342e6"", ""content"": ""there''s """"something"""" I want to tell you"" }' );",44,,"psql"
2014-10-14 18:36:25.519 UTC,"postgres","postgres",30471,"[local]",543d6b47.7707,4,"INSERT",2014-10-14 18:28:23 UTC,1/0,0,LOG,00000,"duration: 0.594 ms statement: insert into jsontest ( somejson ) values ( '{ ""doc"" : ""af42342e6"", ""content"": ""there''s \""something\"" I want to tell you"" }' );",,,,,,,,,"psql"
2014-10-14 18:44:19.911 UTC,"postgres","postgres",30471,"[local]",543d6b47.7707,5,"SELECT",2014-10-14 18:28:23 UTC,1/0,0,LOG,00000,"duration: 0.568 ms statement: select * from jsontest;",,,,,,,,,"psql"
2014-10-14 18:46:10.498 UTC,"postgres","postgres",30471,"[local]",543d6b47.7707,6,"INSERT",2014-10-14 18:28:23 UTC,1/0,0,LOG,00000,"duration: 0.382 ms statement: insert into jsontest ( somejson ) values ( '{ ""doc"" : ""5dde4566ah7"", ""content"": ""now is the time for all \""good\"" men to come to the aid of their respective countries, ethnicities, or \""hoods\""."" }' );",,,,,,,,,"psql"
2014-10-14 18:46:17.457 UTC,"postgres","postgres",30471,"[local]",543d6b47.7707,7,"UPDATE",2014-10-14 18:28:23 UTC,1/0,0,LOG,00000,"duration: 1.053 ms statement: update jsontest set somejson = '{ ""doc"" : ""5dde4566ah7"", ""content"": { ""salmon"" : ""pink"", ""trout"" : ""brown"", ""perch"" : ""\""silver\"""" } }' where id = 2;",,,,,,,,,"psql"
2014-10-14 18:46:36.193 UTC,"postgres","postgres",30471,"[local]",543d6b47.7707,8,"INSERT",2014-10-14 18:28:23 UTC,1/0,0,LOG,00000,"duration: 0.383 ms statement: insert into jsontest (somejson) values ( '{ ""doc"" : ""223cddc77741f"", ""content"" : { ""three things"" : [1, 2, 3] } }' );",,,,,,,,,"psql"
2014-10-14 18:46:54.573 UTC,"postgres","postgres",30471,"[local]",543d6b47.7707,9,"UPDATE",2014-10-14 18:28:23 UTC,1/16,0,ERROR,22P02,"invalid input syntax for type json","Expected JSON value, but found ""]"".",,,,"JSON data, line 1: { ""an array"" : [ ""josh"", ""bruce"", ""tom"", ]...","update jsontest set somejson = '{ ""an array"" : [ ""josh"", ""bruce"", ""tom"", ] }'
where id = 3;",32,,"psql"
2014-10-14 18:47:13.261 UTC,"postgres","postgres",30471,"[local]",543d6b47.7707,10,"UPDATE",2014-10-14 18:28:23 UTC,1/0,0,LOG,00000,"duration: 0.417 ms statement: update jsontest set somejson = '{ ""an array"" : [ ""josh"", ""bruce"", ""tom"" ] }'
where id = 3;",,,,,,,,,"psql"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment