explain.depesz.com

PostgreSQL's explain analyze made readable

Result: urmE

Settings
# exclusive inclusive rows x rows loops node
1. 156.422 156.422 ↑ 27.3 5,114 1

Index Scan using client_task_schedule_entry_dates_entry_id_index on client_task_schedule_entry_dates (cost=0.56..542,625.93 rows=139,772 width=62) (actual time=0.803..156.422 rows=5,114 loops=1)

  • Index Cond: (entry_id = ANY ('{0295fca3-f220-47ae-9545-e302dbc3440c,03de1b77-6517-42a6-af99-fb04c6ef292d,051d28b4-1cf8-4a90-acf5-bbac10b87a5a,0a2ae175-7df4-4482-bab8-07cab996ff90,0b7aa3f2-773f-4ec2-b0af-2a88a701a68f,0d296996-68ad-443d-bbcc-313c4864abe9,0d897ca7-df6e-4108-82db-d9886d637e7e,0e9642c4-3264-43ab-ab2f-a368b5092295,10d48816-58da-4c42-906b-ed38eea3a392,14688252-1312-4fac-892f-0ab2bdd24b0b,1567314b-399e-4f24-98ab-3297cd1e5ee4,1593ad96-5b7b-4613-837f-5b3578ca8a21,18895e60-b488-4343-a4cb-0fa164674f6b,1900839c-7949-4381-9976-e24b2075e493,1aa13e92-2515-4a38-b844-75a7cb77669f,1c4281a3-4458-4422-a5df-ce80b8c1fe3e,22ff9991-a415-4ca7-a1a5-3d314e659f35,2ad2c640-b2f3-4785-a7e9-39d25bbe673e,2eb9c546-81d0-46a3-ad05-713e4c0c7f44,329bde2f-c0d4-4ecf-9883-3bfad7f8fd76,37b010a6-4448-4fb6-bf59-9a55d6776cce,3bc165f1-3025-4932-8444-bd47e6e55a21,3c5cbc4e-9c0a-4f43-be73-6a98249c9fc8,3cfaeccc-9121-4915-92d0-d3d42e7bf93d,420e73d1-703c-4cc4-ad44-fab72120bf95,43225cf0-d737-4940-874a-06de96fa6c2b,47bab797-148e-4b6a-9cd3-f167520966f3,4a4fb0e7-e2c6-4d0a-9df3-43ae79149485,4c3cc27c-5cf2-4f89-ad75-02a070d3c3d0,4f59d5d8-5451-482f-a4d3-3d237cf8e008,500d75ed-ff2d-4ca1-9049-f65a59265bca,50125209-9146-4c26-9e34-15875fe81f0e,503fbaf6-ce3f-4557-b5c9-21efc093aab1,508303b0-ac81-4275-8af5-6afc9414ee53,51c0af77-fe53-4cb1-bdb8-5c141c442762,51feb0e8-94f9-4a48-9dde-722985d6723d,55977a7a-a8e7-4c5f-bf70-ca49d77d588f,56085224-a573-426c-a96a-6f6ac38d8c48,5a48bb63-bf4f-4d55-994c-2bf7bba6dfad,5b32661b-6169-4cdf-b88a-5bd1268912ae,5bbae2a6-c5c8-4cfc-bd28-821a02cf9e27,5e62173b-ddf2-4c22-b8e3-e3504e2852cf,5f778265-9927-45eb-8bcf-05f40257b323,60f34f06-f778-4ee9-b700-805ed5f8329b,641cd617-00a7-4358-a81d-2f38938b8d26,650978c0-c98e-401a-a717-0bd6d016b756,661a9d37-a4ae-4ea6-a9a9-698c58a00ca4,6d3e0f1d-3996-4d08-9b8a-6d73a4aed74d,6fef9a60-7cd3-4d6c-b31f-eec8d6d1abfd,7341b852-ad0d-4527-a26a-d54a2b3287b2,73629ec4-ff90-4857-be7b-c0fb9f47a12e,739e82c5-ba60-4cdf-91a3-550f9b660191,75aa1366-2a15-4719-8c75-71422083081a,797598fa-edd8-4c03-9009-af09210ef4da,7b3e0183-59e2-4a22-8592-e239a563faf3,7c6248ea-a9a9-4ced-be90-8295ef9f0330,7c66b4b0-5eb2-4460-abcb-f4c438f1efc8,7e879220-1ee1-4b25-b73e-3695a1a08f98,7ed147b1-7240-4d37-bbe4-6f005d7d6d45,7fb177c3-003f-4da3-92c5-b010314c533a,81f2b834-cc64-4069-980a-928371594376,84e910d8-6a70-4972-819c-b4f0a67f23ca,8675d2d8-e90c-4ebd-8a59-357705cde620,871d8e9a-009f-4154-ab66-ab580322933d,8875210f-8a44-481a-999c-7e76452c2ee9,8cd61578-0c21-4193-bbaa-e3689821aaac,8d1925c4-4c36-41e6-b387-d56a3ab822cd,8fd70e77-08fa-4aab-b0ae-b3c2705ae66d,90ad9b3a-1f7e-456e-919e-fb91a5aec731,90de3f39-65fc-42d6-99f4-59032f94b1cd,910a52a0-2c5a-4e64-8016-8ed63fcb933f,960513f9-9248-43d4-b6c9-ff09388258cc,99ca0834-0927-410e-9910-cb91ef8aa373,9a6e48bf-f90e-4a50-808b-c5cb1ac1b976,9b2b8490-c4ad-477a-88cf-31d7c3a50ccd,9de55c9b-04d7-4f47-9d29-f06031a05f91,a25368f6-f11d-42bf-8693-561f926ba31a,a3eaaa58-f59f-401f-a820-e36cebe0edd0,a62a6717-0647-4517-880f-b7b237552df2,a63728a3-d658-409a-af15-98dbbd5c4481,a84f12be-62e7-465d-b24b-8161b8c70b64,ab6f2287-a1c3-4f77-8558-f504be9f2357,ae097718-6fd6-4e46-bb71-4f0f9f95fb14,ae6bf88d-959a-4bb2-bd74-e253e6c96ce4,aff8b8ae-4769-4972-a01b-7fad93889bd2,b0fcaca1-3735-4abd-bd6f-4b8e57179300,b2e259f6-b094-4545-a462-95c1c0622ee7,b2fb1636-3191-462a-918c-37768a977db1,b33e6ee8-948d-45cc-b7f7-fe380a7d05ef,b3de150a-b622-4439-b6b5-29005864e104,b63e1071-7a63-499c-9cbf-28723abe6f0f,bc616aba-0cf1-4f2d-854d-325a2beb688c,be099e5e-ebde-4e62-8c48-053299bd1584,be7698b8-67c5-4fbf-a4f0-f36087361784,c04f70f7-600d-45b4-a3c1-b49444931523,c0acc284-a888-4fcb-9e85-f04630b2ff08,c1073d35-3ec6-4d69-90dc-a4338df67e53,c202798c-03b1-4f43-82a7-21d1c3f8a312,c393fc87-7956-42fe-9af2-0d51af5cb21a,c5a68ae9-b0d0-4f6c-8bcc-7398d43bc49c,c7c02f8e-d49d-4304-ba80-920136c7a893,c907ee94-c4db-4cbb-9e7b-dd974d086d20,c960cde1-41ec-4568-839e-da3d8c0dc93f,ccc59044-11c5-45d0-8409-ce0b65779fa4,ccdc7c22-6467-458e-a6d3-7c4ff76f32af,cd41f30b-ad0d-4bf4-8f30-d9189bc87028,cd7c2a1c-9202-479e-8927-2bb5ef9ae46d,cea678b9-68ba-4eb8-b299-ad29d1c9f4e4,cec37927-2824-4fdd-bb67-5c6292326990,d1c8f89e-fd36-4559-a3e8-61b10dbae1a5,d2502466-b0ee-4d38-82a1-6423ec71b2c2,d29a1ac2-e62e-45dd-a02a-c480058654c3,d3a47f5e-6290-4c67-b96b-7a7ec231e172,d46608f0-3152-4156-90b1-bfe85ac63406,d4dd5ff8-9005-49b2-8f51-dad11dbe9ada,d603bc54-12f1-47d8-8f9d-a62f46452097,d63edd92-3eaa-45ca-b3d2-e792539f1fa2,d79e7e06-7324-46fe-9ece-2038a2992178,d801e647-d421-4cc6-affc-61abf24970b9,da0b6bdc-de04-4f5e-99dc-f2ba4cb893c9,dc1198e1-22d1-47ee-9b5c-d43a02a6f739,dc7bf640-40f9-4a33-9d2f-daf6eb37670c,de26b599-e168-4057-ba35-190f0d1e5037,df56c859-bd70-4fc8-86a4-17ac66f33131,dfc27bf1-0207-42ed-ad56-276437a5edff,e1f99c93-26eb-40f7-b61e-21db36181c39,e3500157-1dff-407c-91e2-74dc2857f6c1,e42c28bf-a28a-4b55-b3d1-ed367e66426d,e5d0324a-a2f4-4192-aa14-bc2ecefad4d0,e6f7870c-3c50-4a2b-9af8-22e5961f03cd,e76913bf-6695-4916-8124-62f8cdd497e6,e7b5a83a-33fa-4e63-b269-71a757da9a29,e9fd59ae-8a58-44d0-bf6d-37c3af7d319e,ec5b5d16-e634-4524-b44f-02bd1f591cc8,ed04b442-ba21-42db-9ea3-51ffbab05e91,ed4ac4a9-c5e9-44c5-a25b-683ce8df5861,ef806d1b-3298-43e8-ac34-d57071acc4ef,f24828fe-b71a-471b-9a71-f272fb3a494f,f31f378c-eb0e-48f2-afcc-2c34708cfcac,f69483ba-c4da-44f3-ae6a-805d1846ba8f,f803263f-315e-4889-8d4f-0bd8c2e52711,fe93a156-3ade-4244-8f8a-6886b1b78834}'::uuid[]))
  • Filter: ""overlaps""(start, finish, '2020-05-16 23:00:00+00'::timestamp with time zone, '2020-06-23 22:59:59+00'::timestamp with time zone)
  • Rows Removed by Filter: 382,778
Planning time : 1.589 ms
Execution time : 157.069 ms