fixtures: facetable: 1 row where _city_id = 4 sorted by on

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

1 row where _city_id = 4 sorted by on_earth

descending

This data as json, testall, testnone, testresponse, CSV (advanced)

pk	created	planet_int	on_earth ▼	state	_city_id	_neighborhood	tags	complex_array	distinct_some_null	n
15	2019-01-17 08:00:00	2	0	MC	Memnonia 4	Arcadia Planitia	[]	[]

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE facetable (
    pk integer primary key,
    created text,
    planet_int integer,
    on_earth integer,
    state text,
    _city_id integer,
    _neighborhood text,
    tags text,
    complex_array text,
    distinct_some_null,
    n text,
    FOREIGN KEY ("_city_id") REFERENCES [facet_cities](id)
);

{ "request_duration_ms": 51.52990797068924, "sum_trace_duration_ms": 30.431677878368646, "num_traces": 75, "traces": [ { "type": "sql", "start": 366549.399950855, "end": 366549.40046008, "duration_ms": 0.5092250066809356, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 482, in _refresh_schemas\n for row in await internal_db.execute(\n" ], "database": "__INTERNAL__", "sql": "select database_name, schema_version from catalog_databases", "params": null }, { "type": "sql", "start": 366549.400690838, "end": 366549.400927716, "duration_ms": 0.23687799694016576, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, 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": 366549.401119657, "end": 366549.401295576, "duration_ms": 0.1759190345183015, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, 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": 366549.401423583, "end": 366549.401619316, "duration_ms": 0.19573303870856762, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, 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": 366549.401751156, "end": 366549.401907834, "duration_ms": 0.15667796833440661, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, 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": 366549.402058692, "end": 366549.402225635, "duration_ms": 0.16694300575181842, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n" ], "database": "counters", "sql": "PRAGMA schema_version", "params": null }, { "type": "sql", "start": 366549.402346746, "end": 366549.402500339, "duration_ms": 0.15359302051365376, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n" ], "database": "ephemeral", "sql": "PRAGMA schema_version", "params": null }, { "type": "sql", "start": 366549.402682055, "end": 366549.402912935, "duration_ms": 0.2308799885213375, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 776, in table_view_traced\n resolved = await datasette.resolve_table(request)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1564, in resolve_table\n table_exists = await db.table_exists(table_name)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 405, 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": 366549.403168756, "end": 366549.403355845, "duration_ms": 0.18708902643993497, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.403590033, "end": 366549.403755333, "duration_ms": 0.16529997810721397, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.403929687, "end": 366549.404173979, "duration_ms": 0.24429202312603593, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.40442865, "end": 366549.404747908, "duration_ms": 0.3192580188624561, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.405239058, "end": 366549.405595533, "duration_ms": 0.3564750077202916, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.405819379, "end": 366549.406024101, "duration_ms": 0.20472198957577348, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.408929149, "end": 366549.409239494, "duration_ms": 0.3103450289927423, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 747, in table_view\n response = await table_view_traced(datasette, request)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 800, in table_view_traced\n view_data = await table_view_data(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1185, in table_view_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, n from facetable where \"_city_id\" = :p0 order by on_earth limit 101", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.410297095, "end": 366549.410550622, "duration_ms": 0.2535269595682621, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.410796464, "end": 366549.411020623, "duration_ms": 0.22415898274630308, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.411228664, "end": 366549.411427129, "duration_ms": 0.1984650152735412, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.411616383, "end": 366549.411849967, "duration_ms": 0.23358396720141172, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.412121386, "end": 366549.41231264, "duration_ms": 0.19125401740893722, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.412501198, "end": 366549.412693446, "duration_ms": 0.19224797142669559, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.413098377, "end": 366549.413274548, "duration_ms": 0.1761710154823959, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1229, in table_view_data\n await datasette.expand_foreign_keys(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1068, in expand_foreign_keys\n results = await self.execute(database, sql, list(set(values)))\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": [ 4 ] }, { "type": "sql", "start": 366549.414641144, "end": 366549.415847152, "duration_ms": 1.206008018925786, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/asyncinject/__init__.py\", line 132, in worker\n res = await self._get_awaitable(name, results)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1529, in extra_table_definition\n return await db.get_table_definition(table_name)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 530, 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": 366549.414783481, "end": 366549.416116462, "duration_ms": 1.3329809880815446, "traceback": [ " File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.11/site-packages/asyncinject/__init__.py\", line 132, in worker\n res = await self._get_awaitable(name, results)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1298, in extra_count\n count_rows = list(await db.execute(count_sql, from_sql_params))\n" ], "database": "fixtures", "sql": "select count(*) from facetable where \"_city_id\" = :p0", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.415053369, "end": 366549.416626971, "duration_ms": 1.57360197044909, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1532, in extra_view_definition\n return await db.get_view_definition(table_name)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 550, in get_view_definition\n return await self.get_table_definition(view, \"view\")\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 530, 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": 366549.416029817, "end": 366549.417146662, "duration_ms": 1.1168450000695884, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/asyncinject/__init__.py\", line 132, in worker\n res = await self._get_awaitable(name, results)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1529, in extra_table_definition\n return await db.get_table_definition(table_name)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 540, 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": 366549.417477484, "end": 366549.418648218, "duration_ms": 1.170734001789242, "traceback": [ " File \"plugins/my_plugin.py\", line 167, in suggest\n columns = await self.get_columns(self.sql, self.params)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 138, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 ) limit 0", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.417642636, "end": 366549.419227505, "duration_ms": 1.5848689945414662, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 230, in facet_results\n facet_rows_results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select _city_id as value, count(*) as count from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n )\n where _city_id is not null\n group by _city_id order by count desc, value limit 31", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.419015153, "end": 366549.420217173, "duration_ms": 1.2020199792459607, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 160, in suggest\n columns = await self.get_columns(self.sql, self.params)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 138, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 ) limit 0", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.420833726, "end": 366549.420971285, "duration_ms": 0.1375590218231082, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.421203399, "end": 366549.421355332, "duration_ms": 0.15193299623206258, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.42152674, "end": 366549.421662845, "duration_ms": 0.13610499445348978, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.420445884, "end": 366549.422104966, "duration_ms": 1.6590820159763098, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.42188123, "end": 366549.422299193, "duration_ms": 0.4179629613645375, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.422263958, "end": 366549.422780638, "duration_ms": 0.516679952852428, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.422532668, "end": 366549.423011463, "duration_ms": 0.4787950310856104, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.42317831, "end": 366549.423500579, "duration_ms": 0.32226904295384884, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.42294097, "end": 366549.424044334, "duration_ms": 1.1033639893867075, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.424334285, "end": 366549.424573294, "duration_ms": 0.2390089794062078, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 254, in facet_results\n expanded = await self.ds.expand_foreign_keys(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1068, in expand_foreign_keys\n results = await self.execute(database, sql, list(set(values)))\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": [ 4 ] }, { "type": "sql", "start": 366549.424209954, "end": 366549.425690054, "duration_ms": 1.4801000361330807, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.425856191, "end": 366549.426161578, "duration_ms": 0.30538695864379406, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.426322433, "end": 366549.42660539, "duration_ms": 0.2829569857567549, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.42679637, "end": 366549.427129235, "duration_ms": 0.3328649909235537, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.427318493, "end": 366549.427614475, "duration_ms": 0.29598199762403965, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.42777639, "end": 366549.428119884, "duration_ms": 0.3434940008446574, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.428303999, "end": 366549.428514617, "duration_ms": 0.21061795996502042, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.428658197, "end": 366549.428836021, "duration_ms": 0.17782399663701653, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 459, in suggest\n columns = await self.get_columns(self.sql, self.params)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 138, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 ) limit 0", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.429224509, "end": 366549.429523149, "duration_ms": 0.2986399922519922, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where pk glob \"????-??-*\" limit 100;", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.429684154, "end": 366549.430052203, "duration_ms": 0.3680490190163255, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where created glob \"????-??-*\" limit 100;", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.430549858, "end": 366549.430852773, "duration_ms": 0.3029149957001209, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where planet_int glob \"????-??-*\" limit 100;", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.431048415, "end": 366549.431286667, "duration_ms": 0.23825198877602816, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where on_earth glob \"????-??-*\" limit 100;", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.431447987, "end": 366549.431631087, "duration_ms": 0.18309999722987413, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where state glob \"????-??-*\" limit 100;", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.431770186, "end": 366549.432040557, "duration_ms": 0.27037097606807947, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where _city_id glob \"????-??-*\" limit 100;", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.432219877, "end": 366549.432481866, "duration_ms": 0.26198895648121834, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where _neighborhood glob \"????-??-*\" limit 100;", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.432642028, "end": 366549.432818345, "duration_ms": 0.17631700029596686, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where tags glob \"????-??-*\" limit 100;", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.432982095, "end": 366549.433215923, "duration_ms": 0.2338280319236219, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where complex_array glob \"????-??-*\" limit 100;", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.433407318, "end": 366549.433732081, "duration_ms": 0.32476295018568635, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where distinct_some_null glob \"????-??-*\" limit 100;", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.433900368, "end": 366549.434193135, "duration_ms": 0.2927670138888061, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 \n ) where n glob \"????-??-*\" limit 100;", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.434347852, "end": 366549.434522993, "duration_ms": 0.17514097271487117, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 303, in suggest\n columns = await self.get_columns(self.sql, self.params)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 138, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 ) limit 0", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.434690168, "end": 366549.435081033, "duration_ms": 0.39086496690288186, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 )\n where pk is not null and pk != ''", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.435714558, "end": 366549.436055183, "duration_ms": 0.3406250034458935, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 )\n where planet_int is not null and planet_int != ''", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.43621987, "end": 366549.436549224, "duration_ms": 0.3293540212325752, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 )\n where on_earth is not null and on_earth != ''", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.436951244, "end": 366549.437207408, "duration_ms": 0.2561639994382858, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 )\n where _city_id is not null and _city_id != ''", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.437727822, "end": 366549.43808115, "duration_ms": 0.353328010533005, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 )\n where tags is not null and tags != ''", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.438255128, "end": 366549.438519116, "duration_ms": 0.26398804038763046, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 331, in suggest\n for v in await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 \"_city_id\" = :p0 ) where tags is not null and tags != '' and json_array_length(tags) > 0 limit 100", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.438674514, "end": 366549.438916161, "duration_ms": 0.24164700880646706, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 where \"_city_id\" = :p0 )\n where complex_array is not null and complex_array != ''", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.439079361, "end": 366549.439304792, "duration_ms": 0.22543099476024508, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 331, in suggest\n for v in await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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 \"_city_id\" = :p0 ) where complex_array is not null and complex_array != '' and json_array_length(complex_array) > 0 limit 100", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.439453945, "end": 366549.439616829, "duration_ms": 0.1628840109333396, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select distinct json_type(distinct_some_null)\n from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n where distinct_some_null is not null and distinct_some_null != ''", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.439757672, "end": 366549.440199329, "duration_ms": 0.4416569718159735, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select distinct json_type(n)\n from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n where n is not null and n != ''", "params": { "p0": "4" } }, { "type": "sql", "start": 366549.441108362, "end": 366549.441316195, "duration_ms": 0.20783301442861557, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.441585195, "end": 366549.441756478, "duration_ms": 0.17128296894952655, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1280, in render_template\n extra_script = await await_me_maybe(extra_script)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin.py\", line 90, in inner\n await datasette.get_database().execute(\"select 3 * 5\")\n" ], "database": "_memory", "sql": "select 3 * 5", "params": null }, { "type": "sql", "start": 366549.442094072, "end": 366549.442317234, "duration_ms": 0.2231620019301772, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1367, in _asset_urls\n hook = await await_me_maybe(hook)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin.py\", line 47, in inner\n await datasette.get_database().execute(\"select 3 * 5\")\n" ], "database": "_memory", "sql": "select 3 * 5", "params": null }, { "type": "sql", "start": 366549.443675078, "end": 366549.443897858, "duration_ms": 0.22277998505160213, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.444498543, "end": 366549.444897051, "duration_ms": 0.3985080402344465, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 366549.445381547, "end": 366549.445595801, "duration_ms": 0.214254017919302, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null } ] }