![]() Group Key: ((applications.created)::date) Index Cond: (((country)::text = 'CZ'::text) AND (created >= ' 00:00:00'::timestamp without time zone) AND (created Index Scan using physical_person_id_idx on applications a (cost=0.43.72.77 rows=6 width=0) (actual time=0.006.0.006 rows=1 loops=127558) ![]() Sort Key: (to_char(applications.created, 'YYYY-MM-DD'::text)) WHERE applications.is_preliminary = false To_char(created, 'YYYY-MM-DD') AS "Date", Value of persons.created should be the same as first application.created for this person, regardless the is_preliminary value. "modified" TIMESTAMP WITH TIME ZONE NOT NULLĪLTER TABLE "applications" ADD COLUMN "physical_person_id" UUID NULL ĬREATE INDEX "physical_person_id_idx" ON "applications" ("physical_person_id") ĪLTER TABLE "applications" ADD CONSTRAINT "physical_person_id_fk" FOREIGN KEY ("physical_person_id") REFERENCES "persons" ("id") DEFERRABLE INITIALLY DEFERRED ĬREATE INDEX "country_created" ON "applications" (country, created) ![]() "created" TIMESTAMP WITH TIME ZONE NOT NULL,
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |