explain.depesz.com

PostgreSQL's explain analyze made readable

Result: waNE

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.038 ↑ 1.0 25 1

Limit (cost=0.42..9.14 rows=25 width=16) (actual time=0.015..0.038 rows=25 loops=1)

2. 0.005 0.037 ↑ 15,745.2 25 1

Unique (cost=0.42..137,210.69 rows=393,629 width=16) (actual time=0.015..0.037 rows=25 loops=1)

3. 0.032 0.032 ↑ 15,745.2 25 1

Index Scan using "REF_LIC_SCHET_pkey" on "REF_LIC_SCHET" rls (cost=0.42..136,226.62 rows=393,629 width=16) (actual time=0.013..0.032 rows=25 loops=1)

  • Filter: ("ZONE" = ANY ('{35cccc5c-bc1d-4749-a931-cde5b007b1ab,50685375-87da-46e1-a4a2-1ac93326f315,3bdd57d8-e907-45a3-b110-880625c71087,fa7d76f0-e820-4233-b3c2-3b801336112f,f37b16c4-b7e0-4244-bb00-0d51edf21a7b,666ed72f-c9c4-4f1b-a7ed-e194786cc46b,a95141d0-024c-4570-bfaf-a9dce78eaddb,ded5d225-e7c7-4663-8767-aeb591e3fcfa,e9644267-3ca2-4cdd-ab41-1f9124321733,0152bb3c-89b2-4ff7-83b1-73750d0a7551,2efd2bf1-4eb8-4a2a-9be8-8955dd806a32,a560e43c-e831-46c2-bb70-9bbae431535c,43b0983d-0b70-4990-9dad-bde38bc36da8,1eff350e-cd8c-414f-8f30-bb4e08566a52,25f5f029-bcff-42cd-930b-2b733c8f937a,60a348d1-a659-4a78-a1d3-4efc6fa18c37,adc173bf-7b39-4106-bdfb-49c42e30cfca,91b83dde-5669-4b70-bd3f-aa907431a07a,9fdf5315-d8ac-41a3-b45f-5f8e777100b9,1722a2de-d149-4e08-8b78-ff603d4a5f71,f4e3038c-c22f-4b8f-b23c-8c6395a346c1,524775e9-a88f-4a8a-9e26-08a4305c4568,933793fc-6289-47bf-a53e-af884c597e8a}'::uuid[]))
Planning time : 0.111 ms
Execution time : 0.049 ms