{
  "request_duration_ms": 53.40969800090534,
  "sum_trace_duration_ms": 65.72803299422958,
  "num_traces": 56,
  "traces": [
    {
      "type": "sql",
      "start": 30530.482659602,
      "end": 30530.483095002,
      "duration_ms": 0.43540000115172006,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 363, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 373, in _refresh_schemas\n    for row in await internal_db.execute(\n"
      ],
      "database": "_internal",
      "sql": "select database_name, schema_version from databases",
      "params": null
    },
    {
      "type": "sql",
      "start": 30530.483335961,
      "end": 30530.483680207,
      "duration_ms": 0.34424600016791373,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 363, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 378, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 30530.483865589,
      "end": 30530.484243871,
      "duration_ms": 0.3782819985644892,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 363, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 378, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "_internal",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 30530.484441911,
      "end": 30530.484744428,
      "duration_ms": 0.3025169971806463,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 363, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 378, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "fixtures",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 30530.48490405,
      "end": 30530.485157684,
      "duration_ms": 0.25363399981870316,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 363, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 378, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "fixtures2",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 30530.485294976,
      "end": 30530.485509943,
      "duration_ms": 0.21496699991985224,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 363, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 378, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "extra_database",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 30530.485814073,
      "end": 30530.486018552,
      "duration_ms": 0.2044790016952902,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 548, in get_canned_queries\n    more_queries = await await_me_maybe(more_queries)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 150, in inner\n    await datasette.get_database(database).execute(\"select 1 + 1\")\n"
      ],
      "database": "fixtures",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 30530.486244127,
      "end": 30530.48665403,
      "duration_ms": 0.40990299748955294,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/database.py\", line 451, in get_view_definition\n    return await self.get_table_definition(view, \"view\")\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/database.py\", line 431, in get_table_definition\n    await self.execute(\n"
      ],
      "database": "fixtures",
      "sql": "select sql from sqlite_master where name = :n and type=:t",
      "params": {
        "n": "facetable",
        "t": "view"
      }
    },
    {
      "type": "sql",
      "start": 30530.486293295,
      "end": 30530.486774456,
      "duration_ms": 0.4811609978787601,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/base_events.py\", line 1896, in _run_once\n    handle._run()\n",
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/database.py\", line 311, in table_exists\n    results = await self.execute(\n"
      ],
      "database": "fixtures",
      "sql": "select 1 from sqlite_master where type='table' and name=?",
      "params": [
        "facetable"
      ]
    },
    {
      "type": "sql",
      "start": 30530.486993116,
      "end": 30530.487254,
      "duration_ms": 0.260884000454098,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 640, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 120, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 30530.487488331,
      "end": 30530.48774304,
      "duration_ms": 0.2547090007283259,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 640, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 120, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 30530.487996056,
      "end": 30530.488244099,
      "duration_ms": 0.24804300119285472,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 640, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 120, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 30530.488477312,
      "end": 30530.488666312,
      "duration_ms": 0.18900000213761814,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 640, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 120, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 30530.490349078,
      "end": 30530.49068512,
      "duration_ms": 0.33604199779802,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/views/base.py\", line 361, in get\n    response_or_template_contexts = await self.data(request, **data_kwargs)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/views/table.py\", line 158, in data\n    return await self._data_traced(request, default_labels, _next, _size)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/views/table.py\", line 479, in _data_traced\n    results = await db.execute(sql, params, truncate=True, **extra_args)\n"
      ],
      "database": "fixtures",
      "sql": "select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable order by pk limit 101",
      "params": {}
    },
    {
      "type": "sql",
      "start": 30530.49126685,
      "end": 30530.491880528,
      "duration_ms": 0.6136779993539676,
      "traceback": [
        "  File \"plugins/my_plugin.py\", line 165, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 139, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.491322927,
      "end": 30530.492070353,
      "duration_ms": 0.7474260019080248,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 161, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 139, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.491354438,
      "end": 30530.492295001,
      "duration_ms": 0.9405630007677246,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 460, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 139, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.491384506,
      "end": 30530.492553425,
      "duration_ms": 1.1689189996104687,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 304, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 139, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.492510045,
      "end": 30530.493345266,
      "duration_ms": 0.8352210024895612,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(pk) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where pk glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.492813224,
      "end": 30530.493573554,
      "duration_ms": 0.7603300000482704,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 319, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(pk)\n                from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable )\n                where pk is not null and pk != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.492242809,
      "end": 30530.493790719,
      "duration_ms": 1.5479100002266932,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select pk as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.493521879,
      "end": 30530.494323225,
      "duration_ms": 0.8013459992071148,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(created) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where created glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.49485398,
      "end": 30530.495396779,
      "duration_ms": 0.5427989999589045,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 319, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(planet_int)\n                from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable )\n                where planet_int is not null and planet_int != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.494783761,
      "end": 30530.495969492,
      "duration_ms": 1.185730998258805,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(planet_int) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where planet_int glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.494171399,
      "end": 30530.496199963,
      "duration_ms": 2.0285639984649606,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select created as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.495574178,
      "end": 30530.496999494,
      "duration_ms": 1.4253160006774124,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 319, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(on_earth)\n                from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable )\n                where on_earth is not null and on_earth != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.496622149,
      "end": 30530.497736809,
      "duration_ms": 1.1146600008942187,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select planet_int as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.496148151,
      "end": 30530.498392579,
      "duration_ms": 2.2444280002673622,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(on_earth) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where on_earth glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.498226126,
      "end": 30530.499170029,
      "duration_ms": 0.943903000006685,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select on_earth as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.49855626,
      "end": 30530.499669006,
      "duration_ms": 1.112745998398168,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(state) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where state glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.498312345,
      "end": 30530.499844254,
      "duration_ms": 1.5319090016419068,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 319, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(_city_id)\n                from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable )\n                where _city_id is not null and _city_id != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.499810119,
      "end": 30530.500545168,
      "duration_ms": 0.7350490013777744,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(_city_id) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where _city_id glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.499609426,
      "end": 30530.500879801,
      "duration_ms": 1.270374999876367,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select state as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.500819919,
      "end": 30530.501850438,
      "duration_ms": 1.0305189971404616,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(_neighborhood) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where _neighborhood glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.501533337,
      "end": 30530.502453394,
      "duration_ms": 0.9200570020766463,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select _city_id as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.502013015,
      "end": 30530.502975094,
      "duration_ms": 0.9620790006010793,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(tags) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where tags glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.501794121,
      "end": 30530.503439988,
      "duration_ms": 1.6458669997518882,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 319, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(tags)\n                from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable )\n                where tags is not null and tags != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.503601688,
      "end": 30530.507669191,
      "duration_ms": 4.067502999532735,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 332, in suggest\n    for v in await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select tags from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) where tags is not null and tags != '' and json_array_length(tags) > 0 limit 100",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.503121525,
      "end": 30530.510496476,
      "duration_ms": 7.374951001111185,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(complex_array) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where complex_array glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.502913491,
      "end": 30530.510954788,
      "duration_ms": 8.041296998271719,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select _neighborhood as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.508656201,
      "end": 30530.51203442,
      "duration_ms": 3.378219000296667,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 319, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(complex_array)\n                from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable )\n                where complex_array is not null and complex_array != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.511435449,
      "end": 30530.512330596,
      "duration_ms": 0.8951470008469187,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select tags as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.510877643,
      "end": 30530.513211352,
      "duration_ms": 2.3337090024142526,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(distinct_some_null) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where distinct_some_null glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.513026219,
      "end": 30530.514045803,
      "duration_ms": 1.0195840004598722,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select complex_array as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.512218654,
      "end": 30530.514619536,
      "duration_ms": 2.400882000074489,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 332, in suggest\n    for v in await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select complex_array from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) where complex_array is not null and complex_array != '' and json_array_length(complex_array) > 0 limit 100",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.513367299,
      "end": 30530.515078467,
      "duration_ms": 1.7111679990193807,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(n) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where n glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.514550755,
      "end": 30530.515860013,
      "duration_ms": 1.30925800112891,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct_some_null as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.516031826,
      "end": 30530.516665287,
      "duration_ms": 0.6334610006888397,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select n as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable \n                ) where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 30530.518176218,
      "end": 30530.518466455,
      "duration_ms": 0.2902369997173082,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/views/table.py\", line 603, in _data_traced\n    await self.ds.expand_foreign_keys(\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 760, in expand_foreign_keys\n    results = await self.execute(database, sql, list(set(values)))\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 722, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select id, name\n            from facet_cities\n            where id in (?, ?, ?, ?)",
      "params": [
        1,
        2,
        3,
        4
      ]
    },
    {
      "type": "sql",
      "start": 30530.518837393,
      "end": 30530.519113672,
      "duration_ms": 0.2762789990811143,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 640, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 120, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 30530.523725274,
      "end": 30530.524015352,
      "duration_ms": 0.29007799821556546,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/views/table.py\", line 779, in extra_template\n    \"view_definition\": await db.get_view_definition(table_name),\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/database.py\", line 451, in get_view_definition\n    return await self.get_table_definition(view, \"view\")\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/database.py\", line 431, in get_table_definition\n    await self.execute(\n"
      ],
      "database": "fixtures",
      "sql": "select sql from sqlite_master where name = :n and type=:t",
      "params": {
        "n": "facetable",
        "t": "view"
      }
    },
    {
      "type": "sql",
      "start": 30530.524197569,
      "end": 30530.524467285,
      "duration_ms": 0.2697159980016295,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/views/base.py\", line 459, in get\n    extras = await extras\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/views/table.py\", line 780, in extra_template\n    \"table_definition\": await db.get_table_definition(table_name),\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/database.py\", line 431, in get_table_definition\n    await self.execute(\n"
      ],
      "database": "fixtures",
      "sql": "select sql from sqlite_master where name = :n and type=:t",
      "params": {
        "n": "facetable",
        "t": "table"
      }
    },
    {
      "type": "sql",
      "start": 30530.524639979,
      "end": 30530.524926477,
      "duration_ms": 0.28649799787672237,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/views/base.py\", line 459, in get\n    extras = await extras\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/views/table.py\", line 780, in extra_template\n    \"table_definition\": await db.get_table_definition(table_name),\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/database.py\", line 441, in get_table_definition\n    await self.execute(\n"
      ],
      "database": "fixtures",
      "sql": "select sql from sqlite_master where tbl_name = :n and type='index' and sql is not null",
      "params": {
        "n": "facetable"
      }
    },
    {
      "type": "sql",
      "start": 30530.525910797,
      "end": 30530.526117324,
      "duration_ms": 0.20652699822676368,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 968, in render_template\n    extra_script = await await_me_maybe(extra_script)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin.py\", line 89, in inner\n    await datasette.get_database().execute(\"select 3 * 5\")\n"
      ],
      "database": "_memory",
      "sql": "select 3 * 5",
      "params": null
    },
    {
      "type": "sql",
      "start": 30530.526459599,
      "end": 30530.526701922,
      "duration_ms": 0.2423229998385068,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 1052, in _asset_urls\n    hook = await await_me_maybe(hook)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin.py\", line 46, in inner\n    await datasette.get_database().execute(\"select 3 * 5\")\n"
      ],
      "database": "_memory",
      "sql": "select 3 * 5",
      "params": null
    },
    {
      "type": "sql",
      "start": 30530.527689758,
      "end": 30530.527968292,
      "duration_ms": 0.2785340002446901,
      "traceback": [
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/app.py\", line 640, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.10/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 120, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    }
  ]
}