Skip to content

Instantly share code, notes, and snippets.

@cabecada

cabecada/gist:8406eaabdcd88106832c16aaf9725fdb

Created August 25, 2021 15:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cabecada/8406eaabdcd88106832c16aaf9725fdb to your computer and use it in GitHub Desktop.
Save cabecada/8406eaabdcd88106832c16aaf9725fdb to your computer and use it in GitHub Desktop.
Download ZIP
faceted queries
Raw
gistfile1.txt
CREATE TABLE "nobelists" (
"id" serial primary key,
"name" text NOT NULL,
"birthdate" timestamp,
"deathdate" timestamp,
"birth_country" text,
"birth_state" text,
"birth_city" text,
"url" text,
"discipline" text,
"shared" boolean DEFAULT 'f',
"last_name" text NOT NULL,
"nobel_year" integer NOT NULL,
"deceased" boolean,
"co_winner" text,
"image_url" text,
"image_credit" text);
CREATE TABLE "affiliations" (
"id" serial primary key,
"nobelist_id" integer,
"detail" text NOT NULL,
"degree" text, "year" integer);
CREATE TABLE "citizens" (
"id" serial primary key,
"first_name" text NOT NULL,
"last_name" text,
"gender" text,
"occupation" text,
"birth_city" text,
"birth_state" text,
"birthdate" timestamp,
"social_security" text,
"_fulltext" tsvector);
CREATE EXTENSION faceting
ALTER TABLE "nobelists" ADD "created_at" timestamp
ALTER TABLE "nobelists" ADD "updated_at" timestamp
ALTER TABLE "citizens" ADD "created_at" timestamp
ALTER TABLE "citizens" ADD "updated_at" timestamp
UPDATE nobelists SET created_at = now(), updated_at = now()
UPDATE citizens SET created_at = now(), updated_at = now()
CREATE INDEX "index_citizens_on_updated_at" ON "citizens" ("updated_at")
LOCK TABLE public.schema_migrations IN ACCESS SHARE MODE
LOCK TABLE public.nobelists IN ACCESS SHARE MODE
LOCK TABLE public.affiliations IN ACCESS SHARE MODE
LOCK TABLE public.citizens IN ACCESS SHARE MODE
#pg_dump -s -x -O -f /home/facet/repertoire-faceting-example/db/structure.sql repertoire_faceting_example
#cat data/*.sql | psql -Upostgres repertoire_faceting_example
COPY citizens (first_name, last_name, gender, occupation, birth_city, birth_state, birthdate, social_security) FROM stdin;
UPDATE citizens SET _fulltext = to_tsvector(first_name || ' ' || last_name || ' ' || occupation || ' ' || birth_city || ' ' || birth_state);
UPDATE citizens SET created_at = now(), updated_at = now();
CREATE INDEX index_citizens_on__fulltext ON citizens USING gin(_fulltext);
COPY affiliations (id, nobelist_id, detail, degree, year) FROM stdin;
COPY nobelists (id, name, birthdate, deathdate, birth_country, birth_state, birth_city, url, discipline, shared, last_name, nobel_year, deceased, co_winner, image_url, image_credit) FROM stdin;
UPDATE nobelists SET created_at = now(), updated_at = now();
SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
SELECT facet.wastage(id) FROM nobelists
ALTER TABLE "nobelists" ADD "_packed_id" SERIAL
CREATE MATERIALIZED VIEW "facet"."nobelists_degree_index" AS
SELECT
affiliations.degree AS degree,
facet.signature(nobelists._packed_id),
now() AS updated_at
FROM "nobelists"
INNER JOIN "affiliations" ON "affiliations"."nobelist_id" = "nobelists"."id"
GROUP BY affiliations.degree;
CREATE MATERIALIZED VIEW "facet"."nobelists_discipline_index" AS
SELECT
discipline AS discipline,
facet.signature(nobelists._packed_id),
now() AS updated_at
FROM "nobelists"
GROUP BY "nobelists"."discipline"
SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
SELECT facet.wastage(id) FROM citizens
CREATE MATERIALIZED VIEW "facet"."citizens_gender_index" AS
SELECT
gender AS gender,
facet.signature(citizens.id),
now() AS updated_at
FROM "citizens"
GROUP BY "citizens"."gender";
CREATE MATERIALIZED VIEW "facet"."citizens_occupation_index" AS
SELECT
occupation AS occupation,
facet.signature(citizens.id),
now() AS updated_at
FROM "citizens"
GROUP BY "citizens"."occupation";
CREATE MATERIALIZED VIEW "facet"."citizens_birth_place_index" AS
SELECT
NULL AS birth_place_1,
NULL AS birth_place_2,
0 AS level,
facet.signature(citizens.id),
now() AS updated_at
FROM "citizens"
UNION
SELECT
birth_state AS birth_place_1,
birth_city AS birth_place_2,
2 AS level,
facet.signature(citizens.id),
now() AS updated_at
FROM "citizens"
GROUP BY birth_place_1, birth_place_2
UNION
SELECT
birth_state AS birth_place_1,
NULL AS birth_place_2,
1 AS level,
facet.signature(citizens.id),
now() AS updated_at
FROM "citizens"
GROUP BY birth_place_1;
CREATE MATERIALIZED VIEW "facet"."citizens_birthdate_index" AS
SELECT
NULL AS birthdate_1,
NULL AS birthdate_2,
NULL AS birthdate_3,
0 AS level,
facet.signature(citizens.id),
now() AS updated_at
FROM "citizens"
UNION
SELECT
EXTRACT(year FROM birthdate)::INT AS birthdate_1,
trim(to_char(birthdate, 'Month')) AS birthdate_2,
EXTRACT(day FROM birthdate)::INT AS birthdate_3,
3 AS level,
facet.signature(citizens.id),
now() AS updated_at
FROM "citizens"
GROUP BY birthdate_1, birthdate_2, birthdate_3
UNION
SELECT
EXTRACT(year FROM birthdate)::INT AS birthdate_1,
trim(to_char(birthdate, 'Month')) AS birthdate_2,
NULL AS birthdate_3,
2 AS level,
facet.signature(citizens.id),
now() AS updated_at
FROM "citizens"
GROUP BY birthdate_1, birthdate_2
UNION
SELECT
EXTRACT(year FROM birthdate)::INT AS birthdate_1,
NULL AS birthdate_2,
NULL AS birthdate_3,
1 AS level,
facet.signature(citizens.id),
now() AS updated_at
FROM "citizens"
GROUP BY birthdate_1;
# curl http://localhost:3000/citizens/results
SELECT "citizens".* FROM "citizens" ORDER BY "citizens"."last_name" ASC LIMIT 100
SELECT 1
SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM facet.citizens_gender_index
SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
# curl http://localhost:3000/citizens/counts/gender
SELECT fct.gender, facet.count(fct.signature) FROM (SELECT "facet"."citizens_gender_index"."gender", "facet"."citizens_gender_index"."signature" FROM "facet"."citizens_gender_index") AS fct ORDER BY count DESC, gender ASC
Started GET "/nobelists/counts/discipline.json" for 127.0.0.1 at 2021-08-25 00:32:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"facet"=>"discipline"}
(4.1ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM facet.nobelists_discipline_index
Couldn't find template for digesting: nobelists/counts
(0.6ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(4.1ms) SELECT fct.discipline, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT "facet"."nobelists_discipline_index"."discipline", "facet"."nobelists_discipline_index"."signature" FROM "facet"."nobelists_discipline_index") AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%'))) AS signature) AS mask ORDER BY count DESC, discipline ASC
Completed 200 OK in 26ms (Views: 0.1ms | ActiveRecord: 10.3ms)
Started GET "/nobelists/counts/nobel_year.json" for 127.0.0.1 at 2021-08-25 00:32:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"facet"=>"nobel_year"}
(0.4ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(1.3ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(2.9ms) SELECT fct.nobel_year, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT nobel_year AS nobel_year, facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%') GROUP BY "nobelists"."nobel_year") AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%'))) AS signature) AS mask ORDER BY nobel_year
Completed 200 OK in 7ms (Views: 0.2ms | ActiveRecord: 5.0ms)
Started GET "/nobelists/counts/birth_decade.json" for 127.0.0.1 at 2021-08-25 00:32:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"facet"=>"birth_decade"}
(1.1ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.8ms) SELECT fct.birth_decade, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT ((EXTRACT(year FROM birthdate)::integer / 10::integer) * 10) AS birth_decade, facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%') GROUP BY ((EXTRACT(year FROM birthdate)::integer / 10::integer) * 10)) AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%'))) AS signature) AS mask ORDER BY birth_decade
Completed 200 OK in 4ms (Views: 0.1ms | ActiveRecord: 2.5ms)
Started GET "/nobelists/counts/degree.json" for 127.0.0.1 at 2021-08-25 00:32:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"facet"=>"degree"}
(0.4ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM facet.nobelists_degree_index
Couldn't find template for digesting: nobelists/counts
(1.5ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.4ms) SELECT fct.degree, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT "facet"."nobelists_degree_index"."degree", "facet"."nobelists_degree_index"."signature" FROM "facet"."nobelists_degree_index") AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%'))) AS signature) AS mask ORDER BY count DESC, degree ASC
Completed 200 OK in 4ms (Views: 0.1ms | ActiveRecord: 2.6ms)
Started GET "/nobelists/counts/birth_place.json" for 127.0.0.1 at 2021-08-25 00:32:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"facet"=>"birth_place"}
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
(0.2ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.8ms) SELECT fct.birth_place, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT birth_country AS birth_place, facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%') GROUP BY "nobelists"."birth_country") AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%'))) AS signature) AS mask ORDER BY count DESC, birth_place ASC
Completed 200 OK in 3ms (Views: 0.1ms | ActiveRecord: 1.5ms)
Started GET "/nobelists/results.html" for 127.0.0.1 at 2021-08-25 00:32:31 +0530
Processing by NobelistsController#results as HTML
(0.3ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/results
Nobelist Load (0.6ms) SELECT "nobelists".* FROM "nobelists" WHERE (name ilike '%%')
Rendered nobelists/_nobelist.html.erb (13.4ms)
Completed 200 OK in 57ms (Views: 19.4ms | ActiveRecord: 2.7ms)
Started GET "/nobelists/counts/discipline.json" for 127.0.0.1 at 2021-08-25 00:32:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"facet"=>"discipline"}
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM facet.nobelists_discipline_index
Couldn't find template for digesting: nobelists/counts
Completed 304 Not Modified in 8ms (ActiveRecord: 0.5ms)
Started GET "/nobelists/counts/nobel_year.json" for 127.0.0.1 at 2021-08-25 00:32:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"facet"=>"nobel_year"}
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
Completed 304 Not Modified in 1ms (ActiveRecord: 0.4ms)
Started GET "/nobelists/counts/degree.json" for 127.0.0.1 at 2021-08-25 00:32:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"facet"=>"degree"}
(1.1ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM facet.nobelists_degree_index
Couldn't find template for digesting: nobelists/counts
Completed 304 Not Modified in 3ms (ActiveRecord: 1.2ms)
Started GET "/nobelists/counts/birth_place.json" for 127.0.0.1 at 2021-08-25 00:32:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"facet"=>"birth_place"}
(3.0ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
Completed 304 Not Modified in 5ms (ActiveRecord: 3.2ms)
Started GET "/nobelists/counts/birth_decade.json" for 127.0.0.1 at 2021-08-25 00:32:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"facet"=>"birth_decade"}
(1.5ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
Completed 304 Not Modified in 3ms (ActiveRecord: 1.8ms)
Started GET "/nobelists/results.html" for 127.0.0.1 at 2021-08-25 00:32:31 +0530
Processing by NobelistsController#results as HTML
(0.2ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/results
Nobelist Load (3.0ms) SELECT "nobelists".* FROM "nobelists" WHERE (name ilike '%%')
Rendered nobelists/_nobelist.html.erb (12.5ms)
Completed 200 OK in 23ms (Views: 16.9ms | ActiveRecord: 3.2ms)
Started GET "/nobelists/counts/discipline.json?filter[discipline][]=Physics" for 127.0.0.1 at 2021-08-25 00:33:03 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"filter"=>{"discipline"=>["Physics"]}, "facet"=>"discipline"}
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM facet.nobelists_discipline_index
Couldn't find template for digesting: nobelists/counts
(1.4ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.4ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
unknown OID 75711: failed to recognize type of 'signature'. It will be treated as String.
(0.5ms) SELECT fct.discipline, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT "facet"."nobelists_discipline_index"."discipline", "facet"."nobelists_discipline_index"."signature" FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics')) AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics'))) AS signature) AS mask ORDER BY count DESC, discipline ASC
Completed 200 OK in 8ms (Views: 0.1ms | ActiveRecord: 4.7ms)
Started GET "/nobelists/counts/nobel_year.json?filter[discipline][]=Physics" for 127.0.0.1 at 2021-08-25 00:33:03 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"filter"=>{"discipline"=>["Physics"]}, "facet"=>"nobel_year"}
(0.4ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
(1.6ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(1.2ms) SELECT fct.nobel_year, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT nobel_year AS nobel_year, facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%') GROUP BY "nobelists"."nobel_year") AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics'))) AS signature) AS mask ORDER BY nobel_year
Completed 200 OK in 7ms (Views: 0.1ms | ActiveRecord: 3.7ms)
Started GET "/nobelists/counts/degree.json?filter[discipline][]=Physics" for 127.0.0.1 at 2021-08-25 00:33:03 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"filter"=>{"discipline"=>["Physics"]}, "facet"=>"degree"}
(3.7ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM facet.nobelists_degree_index
Couldn't find template for digesting: nobelists/counts
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.5ms) SELECT fct.degree, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT "facet"."nobelists_degree_index"."degree", "facet"."nobelists_degree_index"."signature" FROM "facet"."nobelists_degree_index") AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics'))) AS signature) AS mask ORDER BY count DESC, degree ASC
Completed 200 OK in 7ms (Views: 0.1ms | ActiveRecord: 4.9ms)
Started GET "/nobelists/counts/birth_decade.json?filter[discipline][]=Physics" for 127.0.0.1 at 2021-08-25 00:33:03 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"filter"=>{"discipline"=>["Physics"]}, "facet"=>"birth_decade"}
(0.4ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(1.7ms) SELECT fct.birth_decade, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT ((EXTRACT(year FROM birthdate)::integer / 10::integer) * 10) AS birth_decade, facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%') GROUP BY ((EXTRACT(year FROM birthdate)::integer / 10::integer) * 10)) AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics'))) AS signature) AS mask ORDER BY birth_decade
Completed 200 OK in 5ms (Views: 0.1ms | ActiveRecord: 2.7ms)
Started GET "/nobelists/counts/birth_place.json?filter[discipline][]=Physics" for 127.0.0.1 at 2021-08-25 00:33:03 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"filter"=>{"discipline"=>["Physics"]}, "facet"=>"birth_place"}
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(1.4ms) SELECT fct.birth_place, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT birth_country AS birth_place, facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%') GROUP BY "nobelists"."birth_country") AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics'))) AS signature) AS mask ORDER BY count DESC, birth_place ASC
Completed 200 OK in 6ms (Views: 0.2ms | ActiveRecord: 2.4ms)
Started GET "/nobelists/results.html?filter[discipline][]=Physics" for 127.0.0.1 at 2021-08-25 00:33:03 +0530
Processing by NobelistsController#results as HTML
Parameters: {"filter"=>{"discipline"=>["Physics"]}}
(0.2ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/results
(0.6ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
Nobelist Load (2.1ms) SELECT "nobelists".* FROM "nobelists" INNER JOIN facet.members((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics'))) AS _refinements_id ON (nobelists._packed_id = _refinements_id) WHERE (name ilike '%%')
Rendered nobelists/_nobelist.html.erb (4.3ms)
Completed 200 OK in 19ms (Views: 4.9ms | ActiveRecord: 2.9ms)
Started GET "/assets/repertoire-faceting/spinner_sm.gif" for 127.0.0.1 at 2021-08-25 00:33:03 +0530
Started GET "/nobelists/counts/discipline.json?filter[discipline][]=Physics&filter[nobel_year][]=1944" for 127.0.0.1 at 2021-08-25 00:33:13 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"filter"=>{"discipline"=>["Physics"], "nobel_year"=>["1944"]}, "facet"=>"discipline"}
(0.4ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM facet.nobelists_discipline_index
Couldn't find template for digesting: nobelists/counts
(1.4ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.7ms) SELECT fct.discipline, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT "facet"."nobelists_discipline_index"."discipline", "facet"."nobelists_discipline_index"."signature" FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics')) AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics')) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (nobel_year IN ('1944')))) AS signature) AS mask ORDER BY count DESC, discipline ASC
Completed 200 OK in 7ms (Views: 0.1ms | ActiveRecord: 3.2ms)
Started GET "/nobelists/counts/nobel_year.json?filter[discipline][]=Physics&filter[nobel_year][]=1944" for 127.0.0.1 at 2021-08-25 00:33:13 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"filter"=>{"discipline"=>["Physics"], "nobel_year"=>["1944"]}, "facet"=>"nobel_year"}
(0.4ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
(2.1ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.6ms) SELECT fct.nobel_year, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT nobel_year AS nobel_year, facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%') AND (nobel_year IN ('1944')) GROUP BY "nobelists"."nobel_year") AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics')) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (nobel_year IN ('1944')))) AS signature) AS mask ORDER BY nobel_year
Completed 200 OK in 7ms (Views: 0.1ms | ActiveRecord: 3.9ms)
Started GET "/nobelists/counts/degree.json?filter[discipline][]=Physics&filter[nobel_year][]=1944" for 127.0.0.1 at 2021-08-25 00:33:13 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"filter"=>{"discipline"=>["Physics"], "nobel_year"=>["1944"]}, "facet"=>"degree"}
(1.9ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM facet.nobelists_degree_index
Couldn't find template for digesting: nobelists/counts
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(1.8ms) SELECT fct.degree, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT "facet"."nobelists_degree_index"."degree", "facet"."nobelists_degree_index"."signature" FROM "facet"."nobelists_degree_index") AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics')) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (nobel_year IN ('1944')))) AS signature) AS mask ORDER BY count DESC, degree ASC
Completed 200 OK in 7ms (Views: 0.1ms | ActiveRecord: 4.7ms)
Started GET "/nobelists/counts/birth_decade.json?filter[discipline][]=Physics&filter[nobel_year][]=1944" for 127.0.0.1 at 2021-08-25 00:33:13 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"filter"=>{"discipline"=>["Physics"], "nobel_year"=>["1944"]}, "facet"=>"birth_decade"}
(0.4ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(1.8ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(2.7ms) SELECT fct.birth_decade, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT ((EXTRACT(year FROM birthdate)::integer / 10::integer) * 10) AS birth_decade, facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%') GROUP BY ((EXTRACT(year FROM birthdate)::integer / 10::integer) * 10)) AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics')) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (nobel_year IN ('1944')))) AS signature) AS mask ORDER BY birth_decade
Completed 200 OK in 8ms (Views: 0.1ms | ActiveRecord: 5.7ms)
Started GET "/nobelists/counts/birth_place.json?filter[discipline][]=Physics&filter[nobel_year][]=1944" for 127.0.0.1 at 2021-08-25 00:33:13 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"filter"=>{"discipline"=>["Physics"], "nobel_year"=>["1944"]}, "facet"=>"birth_place"}
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
(1.0ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(3.6ms) SELECT fct.birth_place, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT birth_country AS birth_place, facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%') GROUP BY "nobelists"."birth_country") AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics')) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (nobel_year IN ('1944')))) AS signature) AS mask ORDER BY count DESC, birth_place ASC
Completed 200 OK in 8ms (Views: 0.2ms | ActiveRecord: 5.5ms)
Started GET "/nobelists/results.html?filter[discipline][]=Physics&filter[nobel_year][]=1944" for 127.0.0.1 at 2021-08-25 00:33:13 +0530
Processing by NobelistsController#results as HTML
Parameters: {"filter"=>{"discipline"=>["Physics"], "nobel_year"=>["1944"]}}
(0.2ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/results
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
Nobelist Load (0.5ms) SELECT "nobelists".* FROM "nobelists" INNER JOIN facet.members((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics')) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (nobel_year IN ('1944')))) AS _refinements_id ON (nobelists._packed_id = _refinements_id) WHERE (name ilike '%%')
Rendered nobelists/_nobelist.html.erb (0.2ms)
Completed 200 OK in 7ms (Views: 3.1ms | ActiveRecord: 1.2ms)
Started GET "/nobelists/counts/discipline.json?filter[discipline][]=Physics&filter[nobel_year][]=1944&filter[birth_decade][]=1890" for 127.0.0.1 at 2021-08-25 00:33:18 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"filter"=>{"discipline"=>["Physics"], "nobel_year"=>["1944"], "birth_decade"=>["1890"]}, "facet"=>"discipline"}
(0.4ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM facet.nobelists_discipline_index
Couldn't find template for digesting: nobelists/counts
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(1.8ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.7ms) SELECT fct.discipline, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT "facet"."nobelists_discipline_index"."discipline", "facet"."nobelists_discipline_index"."signature" FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics')) AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics')) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (nobel_year IN ('1944'))) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (((EXTRACT(year FROM birthdate)::integer / 10::integer) * 10) IN ('1890')))) AS signature) AS mask ORDER BY count DESC, discipline ASC
Completed 200 OK in 7ms (Views: 0.1ms | ActiveRecord: 3.9ms)
Started GET "/nobelists/counts/nobel_year.json?filter[discipline][]=Physics&filter[nobel_year][]=1944&filter[birth_decade][]=1890" for 127.0.0.1 at 2021-08-25 00:33:18 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"filter"=>{"discipline"=>["Physics"], "nobel_year"=>["1944"], "birth_decade"=>["1890"]}, "facet"=>"nobel_year"}
(0.4ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(1.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(1.6ms) SELECT fct.nobel_year, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT nobel_year AS nobel_year, facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%') AND (nobel_year IN ('1944')) GROUP BY "nobelists"."nobel_year") AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics')) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (nobel_year IN ('1944'))) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (((EXTRACT(year FROM birthdate)::integer / 10::integer) * 10) IN ('1890')))) AS signature) AS mask ORDER BY nobel_year
Completed 200 OK in 7ms (Views: 0.1ms | ActiveRecord: 4.4ms)
Started GET "/nobelists/counts/degree.json?filter[discipline][]=Physics&filter[nobel_year][]=1944&filter[birth_decade][]=1890" for 127.0.0.1 at 2021-08-25 00:33:18 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"filter"=>{"discipline"=>["Physics"], "nobel_year"=>["1944"], "birth_decade"=>["1890"]}, "facet"=>"degree"}
(0.4ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM facet.nobelists_degree_index
Couldn't find template for digesting: nobelists/counts
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.9ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.4ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.6ms) SELECT fct.degree, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT "facet"."nobelists_degree_index"."degree", "facet"."nobelists_degree_index"."signature" FROM "facet"."nobelists_degree_index") AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics')) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (nobel_year IN ('1944'))) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (((EXTRACT(year FROM birthdate)::integer / 10::integer) * 10) IN ('1890')))) AS signature) AS mask ORDER BY count DESC, degree ASC
Completed 200 OK in 13ms (Views: 0.1ms | ActiveRecord: 3.0ms)
Started GET "/nobelists/counts/birth_decade.json?filter[discipline][]=Physics&filter[nobel_year][]=1944&filter[birth_decade][]=1890" for 127.0.0.1 at 2021-08-25 00:33:18 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"filter"=>{"discipline"=>["Physics"], "nobel_year"=>["1944"], "birth_decade"=>["1890"]}, "facet"=>"birth_decade"}
(0.9ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(1.2ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.7ms) SELECT fct.birth_decade, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT ((EXTRACT(year FROM birthdate)::integer / 10::integer) * 10) AS birth_decade, facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%') AND (((EXTRACT(year FROM birthdate)::integer / 10::integer) * 10) IN ('1890')) GROUP BY ((EXTRACT(year FROM birthdate)::integer / 10::integer) * 10)) AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics')) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (nobel_year IN ('1944'))) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (((EXTRACT(year FROM birthdate)::integer / 10::integer) * 10) IN ('1890')))) AS signature) AS mask ORDER BY birth_decade
Completed 200 OK in 7ms (Views: 0.1ms | ActiveRecord: 3.6ms)
Started GET "/nobelists/counts/birth_place.json?filter[discipline][]=Physics&filter[nobel_year][]=1944&filter[birth_decade][]=1890" for 127.0.0.1 at 2021-08-25 00:33:18 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"filter"=>{"discipline"=>["Physics"], "nobel_year"=>["1944"], "birth_decade"=>["1890"]}, "facet"=>"birth_place"}
(0.5ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
(1.0ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.4ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(2.3ms) SELECT fct.birth_place, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT birth_country AS birth_place, facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%') GROUP BY "nobelists"."birth_country") AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics')) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (nobel_year IN ('1944'))) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (((EXTRACT(year FROM birthdate)::integer / 10::integer) * 10) IN ('1890')))) AS signature) AS mask ORDER BY count DESC, birth_place ASC
Completed 200 OK in 9ms (Views: 0.1ms | ActiveRecord: 4.9ms)
Started GET "/nobelists/results.html?filter[discipline][]=Physics&filter[nobel_year][]=1944&filter[birth_decade][]=1890" for 127.0.0.1 at 2021-08-25 00:33:18 +0530
Processing by NobelistsController#results as HTML
Parameters: {"filter"=>{"discipline"=>["Physics"], "nobel_year"=>["1944"], "birth_decade"=>["1890"]}}
(0.5ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/results
(1.5ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
Nobelist Load (0.6ms) SELECT "nobelists".* FROM "nobelists" INNER JOIN facet.members((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%%')) OPERATOR(facet.&) (SELECT facet.collect(signature) AS signature FROM "facet"."nobelists_discipline_index" WHERE "facet"."nobelists_discipline_index"."discipline" IN ('Physics')) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (nobel_year IN ('1944'))) OPERATOR(facet.&) (SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (((EXTRACT(year FROM birthdate)::integer / 10::integer) * 10) IN ('1890')))) AS _refinements_id ON (nobelists._packed_id = _refinements_id) WHERE (name ilike '%%')
Rendered nobelists/_nobelist.html.erb (0.3ms)
Completed 200 OK in 7ms (Views: 1.1ms | ActiveRecord: 3.1ms)
Started GET "/nobelists?search=isaac" for 127.0.0.1 at 2021-08-25 00:33:31 +0530
Processing by NobelistsController#index as HTML
Parameters: {"search"=>"isaac"}
Rendered _navigation.html.erb (0.3ms)
Rendered nobelists/index.html.erb within layouts/application (0.6ms)
Completed 200 OK in 5ms (Views: 5.3ms | ActiveRecord: 0.0ms)
Started GET "/nobelists/counts/discipline.json?search=isaac" for 127.0.0.1 at 2021-08-25 00:33:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"search"=>"isaac", "facet"=>"discipline"}
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.7ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM facet.nobelists_discipline_index
Couldn't find template for digesting: nobelists/counts
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.4ms) SELECT fct.discipline, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT "facet"."nobelists_discipline_index"."discipline", "facet"."nobelists_discipline_index"."signature" FROM "facet"."nobelists_discipline_index") AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%isaac%'))) AS signature) AS mask ORDER BY count DESC, discipline ASC
Completed 200 OK in 3ms (Views: 0.1ms | ActiveRecord: 1.7ms)
Started GET "/nobelists/counts/nobel_year.json?search=isaac" for 127.0.0.1 at 2021-08-25 00:33:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"search"=>"isaac", "facet"=>"nobel_year"}
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
(0.2ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT fct.nobel_year, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT nobel_year AS nobel_year, facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%isaac%') GROUP BY "nobelists"."nobel_year") AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%isaac%'))) AS signature) AS mask ORDER BY nobel_year
Completed 200 OK in 2ms (Views: 0.1ms | ActiveRecord: 1.0ms)
Started GET "/nobelists/counts/degree.json?search=isaac" for 127.0.0.1 at 2021-08-25 00:33:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"search"=>"isaac", "facet"=>"degree"}
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM facet.nobelists_degree_index
Couldn't find template for digesting: nobelists/counts
(0.2ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.3ms) SELECT fct.degree, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT "facet"."nobelists_degree_index"."degree", "facet"."nobelists_degree_index"."signature" FROM "facet"."nobelists_degree_index") AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%isaac%'))) AS signature) AS mask ORDER BY count DESC, degree ASC
Completed 200 OK in 2ms (Views: 0.1ms | ActiveRecord: 0.9ms)
Started GET "/nobelists/counts/birth_decade.json?search=isaac" for 127.0.0.1 at 2021-08-25 00:33:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"search"=>"isaac", "facet"=>"birth_decade"}
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.9ms) SELECT fct.birth_decade, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT ((EXTRACT(year FROM birthdate)::integer / 10::integer) * 10) AS birth_decade, facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%isaac%') GROUP BY ((EXTRACT(year FROM birthdate)::integer / 10::integer) * 10)) AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%isaac%'))) AS signature) AS mask ORDER BY birth_decade
Completed 200 OK in 3ms (Views: 0.1ms | ActiveRecord: 1.7ms)
Started GET "/nobelists/counts/birth_place.json?search=isaac" for 127.0.0.1 at 2021-08-25 00:33:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"search"=>"isaac", "facet"=>"birth_place"}
(0.7ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(1.7ms) SELECT fct.birth_place, facet.count(fct.signature OPERATOR(facet.&) mask.signature) FROM (SELECT birth_country AS birth_place, facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%isaac%') GROUP BY "nobelists"."birth_country") AS fct , (SELECT ((SELECT facet.signature(nobelists._packed_id) FROM "nobelists" WHERE (name ilike '%isaac%'))) AS signature) AS mask ORDER BY count DESC, birth_place ASC
Completed 200 OK in 5ms (Views: 0.1ms | ActiveRecord: 3.0ms)
Started GET "/nobelists/results.html?search=isaac" for 127.0.0.1 at 2021-08-25 00:33:31 +0530
Processing by NobelistsController#results as HTML
Parameters: {"search"=>"isaac"}
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/results
Nobelist Load (0.2ms) SELECT "nobelists".* FROM "nobelists" WHERE (name ilike '%isaac%')
Rendered nobelists/_nobelist.html.erb (0.3ms)
Completed 200 OK in 4ms (Views: 2.5ms | ActiveRecord: 0.3ms)
Started GET "/nobelists/counts/discipline.json?search=isaac" for 127.0.0.1 at 2021-08-25 00:33:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"search"=>"isaac", "facet"=>"discipline"}
(1.5ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.7ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM facet.nobelists_discipline_index
Couldn't find template for digesting: nobelists/counts
Completed 304 Not Modified in 7ms (ActiveRecord: 2.1ms)
Started GET "/nobelists/counts/nobel_year.json?search=isaac" for 127.0.0.1 at 2021-08-25 00:33:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"search"=>"isaac", "facet"=>"nobel_year"}
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
Completed 304 Not Modified in 2ms (ActiveRecord: 0.5ms)
Started GET "/nobelists/counts/degree.json?search=isaac" for 127.0.0.1 at 2021-08-25 00:33:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"search"=>"isaac", "facet"=>"degree"}
(0.3ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.1ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM facet.nobelists_degree_index
Couldn't find template for digesting: nobelists/counts
Completed 304 Not Modified in 2ms (ActiveRecord: 0.4ms)
Started GET "/nobelists/counts/birth_decade.json?search=isaac" for 127.0.0.1 at 2021-08-25 00:33:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"search"=>"isaac", "facet"=>"birth_decade"}
(0.4ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
Completed 304 Not Modified in 2ms (ActiveRecord: 0.6ms)
Started GET "/nobelists/counts/birth_place.json?search=isaac" for 127.0.0.1 at 2021-08-25 00:33:31 +0530
Processing by NobelistsController#counts as JSON
Parameters: {"search"=>"isaac", "facet"=>"birth_place"}
(0.9ms) SELECT matviewname FROM pg_matviews WHERE schemaname = 'facet'
(0.2ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/counts
Completed 304 Not Modified in 3ms (ActiveRecord: 1.1ms)
Started GET "/nobelists/results.html?search=isaac" for 127.0.0.1 at 2021-08-25 00:33:31 +0530
Processing by NobelistsController#results as HTML
Parameters: {"search"=>"isaac"}
(0.3ms) SELECT COUNT(updated_at), MAX(updated_at) AS timestamp FROM nobelists
Couldn't find template for digesting: nobelists/results
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment