{
"request_duration_ms": 1687.9323040047893,
"sum_trace_duration_ms": 1644.3815209931927,
"num_traces": 6,
"traces": [
{
"type": "sql",
"start": 41900.193338361,
"end": 41900.193616488,
"duration_ms": 0.2781270013656467,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n await self.ds.refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 364, in refresh_schemas\n await self._refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 374, 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": 41900.214908867,
"end": 41900.215260902,
"duration_ms": 0.35203500010538846,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n await self.ds.refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 364, in refresh_schemas\n await self._refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 379, 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": 41900.215488804,
"end": 41900.215729057,
"duration_ms": 0.24025300081120804,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n await self.ds.refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 364, in refresh_schemas\n await self._refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 379, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
],
"database": "covid",
"sql": "PRAGMA schema_version",
"params": null
},
{
"type": "sql",
"start": 41900.215911402,
"end": 41900.216119572,
"duration_ms": 0.20816999312955886,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n await self.ds.refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 364, in refresh_schemas\n await self._refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 379, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
],
"database": "la-times",
"sql": "PRAGMA schema_version",
"params": null
},
{
"type": "sql",
"start": 41900.217234627,
"end": 41900.219122012,
"duration_ms": 1.8873849985538982,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/database.py\", line 59, in data\n return await QueryView(self.ds).data(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/database.py\", line 255, in data\n named_parameters = named_parameters or await derive_named_parameters(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 1124, in derive_named_parameters\n results = await db.execute(explain, {p: None for p in possible_params})\n"
],
"database": "covid",
"sql": "explain with cte as (\r\n select rowid, date, county, state, fips, cases, deaths\r\n from ny_times_us_counties\r\n),\r\ntruncated as (\r\n select null as _facet, null as facet_name, null as facet_count, rowid, date, county, state, fips, cases, deaths\r\n from cte order by date desc limit 4\r\n),\r\nstate_facet as (\r\n select 'state' as _facet, state as facet_name, count(*) as facet_count,\r\n null, null, null, null, null, null, null\r\n from cte group by facet_name order by facet_count desc limit 3\r\n),\r\nfips_facet as (\r\n select 'fips' as _facet, fips as facet_name, count(*) as facet_count,\r\n null, null, null, null, null, null, null\r\n from cte group by facet_name order by facet_count desc limit 3\r\n),\r\ncounty_facet as (\r\n select 'county' as _facet, county as facet_name, count(*) as facet_count,\r\n null, null, null, null, null, null, null\r\n from cte group by facet_name order by facet_count desc limit 3\r\n)\r\nselect * from truncated\r\nunion all select * from state_facet\r\nunion all select * from fips_facet\r\nunion all select * from county_facet",
"params": {}
},
{
"type": "sql",
"start": 41900.231344963,
"end": 41901.872760514,
"duration_ms": 1641.415550999227,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/database.py\", line 59, in data\n return await QueryView(self.ds).data(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/database.py\", line 370, in data\n results = await self.ds.execute(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n return await self.databases[db_name].execute(\n"
],
"database": "covid",
"sql": "with cte as (\r\n select rowid, date, county, state, fips, cases, deaths\r\n from ny_times_us_counties\r\n),\r\ntruncated as (\r\n select null as _facet, null as facet_name, null as facet_count, rowid, date, county, state, fips, cases, deaths\r\n from cte order by date desc limit 4\r\n),\r\nstate_facet as (\r\n select 'state' as _facet, state as facet_name, count(*) as facet_count,\r\n null, null, null, null, null, null, null\r\n from cte group by facet_name order by facet_count desc limit 3\r\n),\r\nfips_facet as (\r\n select 'fips' as _facet, fips as facet_name, count(*) as facet_count,\r\n null, null, null, null, null, null, null\r\n from cte group by facet_name order by facet_count desc limit 3\r\n),\r\ncounty_facet as (\r\n select 'county' as _facet, county as facet_name, count(*) as facet_count,\r\n null, null, null, null, null, null, null\r\n from cte group by facet_name order by facet_count desc limit 3\r\n)\r\nselect * from truncated\r\nunion all select * from state_facet\r\nunion all select * from fips_facet\r\nunion all select * from county_facet",
"params": {
"_trace": "1"
}
}
]
}