{
  "request_duration_ms": 52.71070100206998,
  "sum_trace_duration_ms": 17.863819990452612,
  "num_traces": 53,
  "traces": [
    {
      "type": "sql",
      "start": 21248.343214535,
      "end": 21248.34360344,
      "duration_ms": 0.3889049985446036,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 123, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 353, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 363, 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": 21248.343862853,
      "end": 21248.344817283,
      "duration_ms": 0.9544300010020379,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 123, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 353, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 368, 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": 21248.345024556,
      "end": 21248.345310475,
      "duration_ms": 0.2859189989976585,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 123, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 353, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 368, 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": 21248.345450612,
      "end": 21248.345946525,
      "duration_ms": 0.495913001941517,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 123, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 353, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 368, 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": 21248.346108566,
      "end": 21248.346430429,
      "duration_ms": 0.3218630008632317,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 123, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 353, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 368, 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": 21248.34693062,
      "end": 21248.347168398,
      "duration_ms": 0.23777800015523098,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 524, in get_canned_queries\n    more_queries = await await_me_maybe(more_queries)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 67, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 144, in inner\n    await datasette.get_database(database).execute(\"select 1 + 1\")\n"
      ],
      "database": "fixtures",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 21248.347345417,
      "end": 21248.347699371,
      "duration_ms": 0.35395399754634127,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 348, in data\n    is_view = bool(await db.get_view_definition(table))\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 430, in get_view_definition\n    return await self.get_table_definition(view, \"view\")\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 410, 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": 21248.347846114,
      "end": 21248.34813199,
      "duration_ms": 0.28587599808815867,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 477, in view_get\n    response_or_template_contexts = await self.data(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 349, in data\n    table_exists = bool(await db.table_exists(table))\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 290, 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": 21248.348378191,
      "end": 21248.348627034,
      "duration_ms": 0.2488430000084918,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 610, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 67, 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": 21248.348856686,
      "end": 21248.349069485,
      "duration_ms": 0.21279900101944804,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 610, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 67, 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": 21248.349258684,
      "end": 21248.349471041,
      "duration_ms": 0.21235700114630163,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 610, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 67, 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": 21248.349653771,
      "end": 21248.349938293,
      "duration_ms": 0.28452199694584124,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 610, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 67, 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": 21248.351937093,
      "end": 21248.352332358,
      "duration_ms": 0.3952650004066527,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 262, in get\n    return await self.view_get(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 477, in view_get\n    response_or_template_contexts = await self.data(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 619, in data\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 from facetable order by pk limit 101",
      "params": {}
    },
    {
      "type": "sql",
      "start": 21248.353060457,
      "end": 21248.353396162,
      "duration_ms": 0.3357050009071827,
      "traceback": [
        "  File \"plugins/my_plugin.py\", line 155, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 124, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable ) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.353801562,
      "end": 21248.354156517,
      "duration_ms": 0.3549550019670278,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 146, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 124, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable ) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.354351277,
      "end": 21248.354707345,
      "duration_ms": 0.3560679979273118,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select pk, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null from facetable \n                ) where pk is not null\n                group by pk\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.354870618,
      "end": 21248.355227223,
      "duration_ms": 0.3566049999790266,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select created, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null from facetable \n                ) where created is not null\n                group by created\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.355878244,
      "end": 21248.356229847,
      "duration_ms": 0.35160299739800394,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select planet_int, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null from facetable \n                ) where planet_int is not null\n                group by planet_int\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.356638301,
      "end": 21248.356999695,
      "duration_ms": 0.3613939989008941,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select on_earth, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null from facetable \n                ) where on_earth is not null\n                group by on_earth\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.357411008,
      "end": 21248.357901788,
      "duration_ms": 0.49077999938162975,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select state, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null from facetable \n                ) where state is not null\n                group by state\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.358307543,
      "end": 21248.35860063,
      "duration_ms": 0.29308699959074147,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select _city_id, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null from facetable \n                ) where _city_id is not null\n                group by _city_id\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.359043407,
      "end": 21248.359355876,
      "duration_ms": 0.3124690010736231,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select _neighborhood, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null from facetable \n                ) where _neighborhood is not null\n                group by _neighborhood\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.359748165,
      "end": 21248.36003974,
      "duration_ms": 0.29157500102883205,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select tags, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null from facetable \n                ) where tags is not null\n                group by tags\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.360418188,
      "end": 21248.360739177,
      "duration_ms": 0.3209889982827008,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select complex_array, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null from facetable \n                ) where complex_array is not null\n                group by complex_array\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.361121644,
      "end": 21248.361484727,
      "duration_ms": 0.36308299968368374,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct_some_null, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null from facetable \n                ) where distinct_some_null is not null\n                group by distinct_some_null\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.361780161,
      "end": 21248.362080242,
      "duration_ms": 0.30008099929546006,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 445, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 124, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable ) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.362252463,
      "end": 21248.362728909,
      "duration_ms": 0.4764459990838077,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable \n                ) where pk glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.362896273,
      "end": 21248.363241385,
      "duration_ms": 0.3451119991950691,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable \n                ) where created glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.363948963,
      "end": 21248.36426926,
      "duration_ms": 0.3202970001439098,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable \n                ) where planet_int glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.36442434,
      "end": 21248.364753486,
      "duration_ms": 0.32914599796640687,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable \n                ) where on_earth glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.364909869,
      "end": 21248.36521268,
      "duration_ms": 0.3028110004379414,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable \n                ) where state glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.365370132,
      "end": 21248.365668174,
      "duration_ms": 0.2980419994855765,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable \n                ) where _city_id glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.365844643,
      "end": 21248.366151418,
      "duration_ms": 0.30677499671583064,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable \n                ) where _neighborhood glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.366311376,
      "end": 21248.366595238,
      "duration_ms": 0.28386199846863747,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable \n                ) where tags glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.366771107,
      "end": 21248.367059448,
      "duration_ms": 0.288340997940395,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable \n                ) where complex_array glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.367208019,
      "end": 21248.367477938,
      "duration_ms": 0.269919000857044,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable \n                ) where distinct_some_null glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.367642258,
      "end": 21248.367983358,
      "duration_ms": 0.34109999978682026,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 289, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 124, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable ) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.368164795,
      "end": 21248.368539987,
      "duration_ms": 0.3751920012291521,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable )\n                where pk is not null and pk != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.369154378,
      "end": 21248.369438764,
      "duration_ms": 0.28438599838409573,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable )\n                where planet_int is not null and planet_int != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.36958545,
      "end": 21248.369943578,
      "duration_ms": 0.3581279997888487,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable )\n                where on_earth is not null and on_earth != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.37052265,
      "end": 21248.370909173,
      "duration_ms": 0.38652300281682983,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable )\n                where _city_id is not null and _city_id != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.371435485,
      "end": 21248.37178701,
      "duration_ms": 0.3515249991323799,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable )\n                where tags is not null and tags != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.371960905,
      "end": 21248.372238329,
      "duration_ms": 0.2774240019789431,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 317, in suggest\n    for v in await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable ) where tags is not null and tags != '' and json_array_length(tags) > 0 limit 100",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.373046828,
      "end": 21248.373376798,
      "duration_ms": 0.32997000016621314,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable )\n                where complex_array is not null and complex_array != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.37352818,
      "end": 21248.373853034,
      "duration_ms": 0.32485400151927024,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 697, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 317, in suggest\n    for v in await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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 from facetable ) where complex_array is not null and complex_array != '' and json_array_length(complex_array) > 0 limit 100",
      "params": []
    },
    {
      "type": "sql",
      "start": 21248.375966154,
      "end": 21248.37629309,
      "duration_ms": 0.3269360022386536,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 732, in data\n    await self.ds.expand_foreign_keys(database, table, column, values)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 677, in expand_foreign_keys\n    results = await self.execute(database, sql, list(set(values)))\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 639, 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": 21248.376638018,
      "end": 21248.376945545,
      "duration_ms": 0.30752699967706576,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 610, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 67, 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": 21248.382302556,
      "end": 21248.382683986,
      "duration_ms": 0.38142999983392656,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 882, in extra_template\n    \"view_definition\": await db.get_view_definition(table),\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 430, in get_view_definition\n    return await self.get_table_definition(view, \"view\")\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 410, 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": 21248.382867683,
      "end": 21248.383096825,
      "duration_ms": 0.22914199871593155,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 572, in view_get\n    extras = await extras\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 883, in extra_template\n    \"table_definition\": await db.get_table_definition(table),\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 410, 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": 21248.383225561,
      "end": 21248.383604625,
      "duration_ms": 0.3790640002989676,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 572, in view_get\n    extras = await extras\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 883, in extra_template\n    \"table_definition\": await db.get_table_definition(table),\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 420, 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": 21248.384861336,
      "end": 21248.385118547,
      "duration_ms": 0.2572110024630092,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 860, in render_template\n    extra_script = await await_me_maybe(extra_script)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 67, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin.py\", line 87, in inner\n    await datasette.get_database().execute(\"select 3 * 5\")\n"
      ],
      "database": "_memory",
      "sql": "select 3 * 5",
      "params": null
    },
    {
      "type": "sql",
      "start": 21248.385474855,
      "end": 21248.385765684,
      "duration_ms": 0.29082900073262863,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 944, in _asset_urls\n    hook = await await_me_maybe(hook)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 67, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin.py\", line 44, in inner\n    await datasette.get_database().execute(\"select 3 * 5\")\n"
      ],
      "database": "_memory",
      "sql": "select 3 * 5",
      "params": null
    },
    {
      "type": "sql",
      "start": 21248.387292672,
      "end": 21248.387567682,
      "duration_ms": 0.2750099993136246,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 610, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 67, 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
    }
  ]
}