Limit  (cost=67.89..67.90 rows=1 width=1′405) (actual time=0.870..0.880 rows=0 loops=1)
  Output: "Call"."Id", "Call"."StartDate", "Call"."CreatedById", "CreatedBy"."Name", "CreatedBy"."PhotoId", "Call"."DirectionId", (COALESCE("SysCallDirectionLcz"."Name", "Direction"."Name")), "Direction"."ImageId", "Call"."EndDate", "Call"."ResultId", (COALESCE("SysActivityResultLcz"."Name", "Result"."Name")), "Call"."Comment", "Call"."ContactId", "Contact"."Name", "Contact"."PhotoId", "Call"."Duration", "Call"."GoOwnerId", "GoOwner"."Name", "GoOwner"."PhotoId", "Call"."GoCallRecordURL", 'Call'::text, 'Terrasoft.GoCallTimelineItemView'::text, 'https://merchants.yacrm.taxi.yandex.net/img/entity/hash/TimelineTileSetting/Image/aeca6df0-5c89-4066-bdfa-eff486ae8fed'::text, 'aeca6df0-5c89-4066-bdfa-eff486ae8fed'::text
  Buffers: shared hit=15 read=6
  ->  Sort  (cost=67.89..67.90 rows=1 width=1′405) (actual time=0.868..0.878 rows=0 loops=1)
        Output: "Call"."Id", "Call"."StartDate", "Call"."CreatedById", "CreatedBy"."Name", "CreatedBy"."PhotoId", "Call"."DirectionId", (COALESCE("SysCallDirectionLcz"."Name", "Direction"."Name")), "Direction"."ImageId", "Call"."EndDate", "Call"."ResultId", (COALESCE("SysActivityResultLcz"."Name", "Result"."Name")), "Call"."Comment", "Call"."ContactId", "Contact"."Name", "Contact"."PhotoId", "Call"."Duration", "Call"."GoOwnerId", "GoOwner"."Name", "GoOwner"."PhotoId", "Call"."GoCallRecordURL", 'Call'::text, 'Terrasoft.GoCallTimelineItemView'::text, 'https://merchants.yacrm.taxi.yandex.net/img/entity/hash/TimelineTileSetting/Image/aeca6df0-5c89-4066-bdfa-eff486ae8fed'::text, 'aeca6df0-5c89-4066-bdfa-eff486ae8fed'::text
        Sort Key: "Call"."StartDate" DESC NULLS LAST, "Call"."Id" DESC NULLS LAST
        Sort Method: quicksort  Memory: 25kB
        Buffers: shared hit=15 read=6
        ->  Nested Loop Semi Join  (cost=32.85..67.88 rows=1 width=1′405) (actual time=0.859..0.869 rows=0 loops=1)
              Output: "Call"."Id", "Call"."StartDate", "Call"."CreatedById", "CreatedBy"."Name", "CreatedBy"."PhotoId", "Call"."DirectionId", COALESCE("SysCallDirectionLcz"."Name", "Direction"."Name"), "Direction"."ImageId", "Call"."EndDate", "Call"."ResultId", COALESCE("SysActivityResultLcz"."Name", "Result"."Name"), "Call"."Comment", "Call"."ContactId", "Contact"."Name", "Contact"."PhotoId", "Call"."Duration", "Call"."GoOwnerId", "GoOwner"."Name", "GoOwner"."PhotoId", "Call"."GoCallRecordURL", 'Call'::text, 'Terrasoft.GoCallTimelineItemView'::text, 'https://merchants.yacrm.taxi.yandex.net/img/entity/hash/TimelineTileSetting/Image/aeca6df0-5c89-4066-bdfa-eff486ae8fed'::text, 'aeca6df0-5c89-4066-bdfa-eff486ae8fed'::text
              Buffers: shared hit=15 read=6
              ->  Nested Loop Semi Join  (cost=32.43..65.24 rows=1 width=1′328) (actual time=0.858..0.867 rows=0 loops=1)
                    Output: "Call"."Id", "Call"."StartDate", "Call"."CreatedById", "Call"."DirectionId", "Call"."EndDate", "Call"."ResultId", "Call"."Comment", "Call"."ContactId", "Call"."Duration", "Call"."GoOwnerId", "Call"."GoCallRecordURL", "CreatedBy"."Name", "CreatedBy"."PhotoId", "Direction"."Name", "Direction"."ImageId", "SysCallDirectionLcz"."Name", "Result"."Name", "SysActivityResultLcz"."Name", "Contact"."Name", "Contact"."PhotoId", "GoOwner"."Name", "GoOwner"."PhotoId", "GoBusinessCall"."GoCallId"
                    Join Filter: ("Call"."Id" = "GoBusinessCall"."GoCallId")
                    Buffers: shared hit=15 read=6
                    ->  Nested Loop Left Join  (cost=27.99..55.18 rows=20 width=1′312) (actual time=0.769..0.820 rows=20 loops=1)
                          Output: "Call"."Id", "Call"."StartDate", "Call"."CreatedById", "Call"."DirectionId", "Call"."EndDate", "Call"."ResultId", "Call"."Comment", "Call"."ContactId", "Call"."Duration", "Call"."GoOwnerId", "Call"."GoCallRecordURL", "CreatedBy"."Name", "CreatedBy"."PhotoId", "Direction"."Name", "Direction"."ImageId", "SysCallDirectionLcz"."Name", "Result"."Name", "SysActivityResultLcz"."Name", "Contact"."Name", "Contact"."PhotoId", "GoOwner"."Name", "GoOwner"."PhotoId"
                          Inner Unique: true
                          Buffers: shared hit=15 read=5
                          ->  Hash Left Join  (cost=27.84..42.38 rows=20 width=1′275) (actual time=0.751..0.794 rows=20 loops=1)
                                Output: "Call"."Id", "Call"."StartDate", "Call"."CreatedById", "Call"."DirectionId", "Call"."EndDate", "Call"."ResultId", "Call"."Comment", "Call"."ContactId", "Call"."Duration", "Call"."GoOwnerId", "Call"."GoCallRecordURL", "CreatedBy"."Name", "CreatedBy"."PhotoId", "Direction"."Name", "Direction"."ImageId", "SysCallDirectionLcz"."Name", "Result"."Name", "SysActivityResultLcz"."Name", "Contact"."Name", "Contact"."PhotoId"
                                Hash Cond: ("Call"."ContactId" = "Contact"."Id")
                                Inner Unique: true
                                Buffers: shared hit=15 read=5
                                ->  Hash Left Join  (cost=13.34..27.83 rows=20 width=1′238) (actual time=0.540..0.575 rows=20 loops=1)
                                      Output: "Call"."Id", "Call"."StartDate", "Call"."CreatedById", "Call"."DirectionId", "Call"."EndDate", "Call"."ResultId", "Call"."Comment", "Call"."ContactId", "Call"."Duration", "Call"."GoOwnerId", "Call"."GoCallRecordURL", "CreatedBy"."Name", "CreatedBy"."PhotoId", "Direction"."Name", "Direction"."ImageId", "SysCallDirectionLcz"."Name", "Result"."Name", "SysActivityResultLcz"."Name"
                                      Hash Cond: ("Direction"."Id" = "SysCallDirectionLcz"."RecordId")
                                      Inner Unique: true
                                      Buffers: shared hit=5 read=5
                                      ->  Hash Left Join  (cost=11.65..26.00 rows=20 width=1′241) (actual time=0.480..0.511 rows=20 loops=1)
                                            Output: "Call"."Id", "Call"."StartDate", "Call"."CreatedById", "Call"."DirectionId", "Call"."EndDate", "Call"."ResultId", "Call"."Comment", "Call"."ContactId", "Call"."Duration", "Call"."GoOwnerId", "Call"."GoCallRecordURL", "CreatedBy"."Name", "CreatedBy"."PhotoId", "Direction"."Name", "Direction"."ImageId", "Direction"."Id", "Result"."Name", "SysActivityResultLcz"."Name"
                                            Hash Cond: ("Call"."DirectionId" = "Direction"."Id")
                                            Inner Unique: true
                                            Buffers: shared hit=5 read=4
                                            ->  Nested Loop Left Join  (cost=10.58..24.83 rows=20 width=693) (actual time=0.425..0.449 rows=20 loops=1)
                                                  Output: "Call"."Id", "Call"."StartDate", "Call"."CreatedById", "Call"."DirectionId", "Call"."EndDate", "Call"."ResultId", "Call"."Comment", "Call"."ContactId", "Call"."Duration", "Call"."GoOwnerId", "Call"."GoCallRecordURL", "CreatedBy"."Name", "CreatedBy"."PhotoId", "Result"."Name", "SysActivityResultLcz"."Name"
                                                  Inner Unique: true
                                                  Buffers: shared hit=5 read=3
                                                  ->  Hash Right Join  (cost=10.43..16.90 rows=20 width=656) (actual time=0.399..0.411 rows=20 loops=1)
                                                        Output: "Call"."Id", "Call"."StartDate", "Call"."CreatedById", "Call"."DirectionId", "Call"."EndDate", "Call"."ResultId", "Call"."Comment", "Call"."ContactId", "Call"."Duration", "Call"."GoOwnerId", "Call"."GoCallRecordURL", "Result"."Name", "SysActivityResultLcz"."Name"
                                                        Hash Cond: ("Result"."Id" = "Call"."ResultId")
                                                        Buffers: shared hit=3 read=3
                                                        ->  Hash Right Join  (cost=5.87..12.25 rows=24 width=554) (actual time=0.313..0.326 rows=24 loops=1)
                                                              Output: "Result"."Name", "Result"."Id", "SysActivityResultLcz"."Name"
                                                              Hash Cond: ("SysActivityResultLcz"."RecordId" = "Result"."Id")
                                                              Inner Unique: true
                                                              Buffers: shared read=3
                                                              ->  Bitmap Heap Scan on public."SysActivityResultLcz"  (cost=4.33..10.63 rows=24 width=38) (actual time=0.067..0.069 rows=24 loops=1)
                                                                    Output: "SysActivityResultLcz"."Id", "SysActivityResultLcz"."ModifiedOn", "SysActivityResultLcz"."RecordId", "SysActivityResultLcz"."SysCultureId", "SysActivityResultLcz"."Name", "SysActivityResultLcz"."Description"
                                                                    Recheck Cond: ("SysActivityResultLcz"."SysCultureId" = '1a778e3f-0a8e-e111-84a3-00155d054c03'::uuid)
                                                                    Heap Blocks: exact=1
                                                                    Buffers: shared read=2
                                                                    ->  Bitmap Index Scan on "IPfDTUGIZhlP6tue6qP6perKcHA"  (cost=0.00..4.33 rows=24 width=0) (actual time=0.034..0.034 rows=24 loops=1)
                                                                          Index Cond: ("SysActivityResultLcz"."SysCultureId" = '1a778e3f-0a8e-e111-84a3-00155d054c03'::uuid)
                                                                          Buffers: shared read=1
                                                              ->  Hash  (cost=1.24..1.24 rows=24 width=532) (actual time=0.234..0.235 rows=24 loops=1)
                                                                    Output: "Result"."Name", "Result"."Id"
                                                                    Buckets: 1′024 (originally 1′024)  Batches: 1 (originally 1)  Memory Usage: 10kB
                                                                    Buffers: shared read=1
                                                                    ->  Seq Scan on public."ActivityResult" "Result"  (cost=0.00..1.24 rows=24 width=532) (actual time=0.210..0.214 rows=24 loops=1)
                                                                          Output: "Result"."Name", "Result"."Id"
                                                                          Buffers: shared read=1
                                                        ->  Hash  (cost=4.30..4.30 rows=20 width=118) (actual time=0.060..0.060 rows=20 loops=1)
                                                              Output: "Call"."Id", "Call"."StartDate", "Call"."CreatedById", "Call"."DirectionId", "Call"."EndDate", "Call"."ResultId", "Call"."Comment", "Call"."ContactId", "Call"."Duration", "Call"."GoOwnerId", "Call"."GoCallRecordURL"
                                                              Buckets: 1′024 (originally 1′024)  Batches: 1 (originally 1)  Memory Usage: 11kB
                                                              Buffers: shared hit=3
                                                              ->  Seq Scan on public."Call"  (cost=0.00..4.30 rows=20 width=118) (actual time=0.021..0.041 rows=20 loops=1)
                                                                    Output: "Call"."Id", "Call"."StartDate", "Call"."CreatedById", "Call"."DirectionId", "Call"."EndDate", "Call"."ResultId", "Call"."Comment", "Call"."ContactId", "Call"."Duration", "Call"."GoOwnerId", "Call"."GoCallRecordURL"
                                                                    Filter: (("Call"."StartDate" IS NOT NULL) AND ("Call"."StartDate" >= '2024-10-09 21:00:00'::timestamp without time zone) AND ("Call"."StartDate" <= '2025-04-10 20:59:59.999'::timestamp without time zone))
                                                                    Rows Removed by Filter: 42
                                                                    Buffers: shared hit=3
                                                  ->  Memoize  (cost=0.15..2.57 rows=1 width=53) (actual time=0.001..0.001 rows=1 loops=20)
                                                        Output: "CreatedBy"."Name", "CreatedBy"."PhotoId", "CreatedBy"."Id"
                                                        Cache Key: "Call"."CreatedById"
                                                        Cache Mode: logical
                                                        Hits: 19  Misses: 1  Evictions: 0  Overflows: 0  Memory Usage: 1kB
                                                        Buffers: shared hit=2
                                                        ->  Index Scan using "PKDR5ErUGy8HVE2ImrX39YL4VU" on public."Contact" "CreatedBy"  (cost=0.14..2.56 rows=1 width=53) (actual time=0.017..0.017 rows=1 loops=1)
                                                              Output: "CreatedBy"."Name", "CreatedBy"."PhotoId", "CreatedBy"."Id"
                                                              Index Cond: ("CreatedBy"."Id" = "Call"."CreatedById")
                                                              Buffers: shared hit=2
                                            ->  Hash  (cost=1.03..1.03 rows=3 width=548) (actual time=0.042..0.042 rows=3 loops=1)
                                                  Output: "Direction"."Name", "Direction"."ImageId", "Direction"."Id"
                                                  Buckets: 1′024 (originally 1′024)  Batches: 1 (originally 1)  Memory Usage: 9kB
                                                  Buffers: shared read=1
                                                  ->  Seq Scan on public."CallDirection" "Direction"  (cost=0.00..1.03 rows=3 width=548) (actual time=0.034..0.035 rows=3 loops=1)
                                                        Output: "Direction"."Name", "Direction"."ImageId", "Direction"."Id"
                                                        Buffers: shared read=1
                                      ->  Hash  (cost=1.65..1.65 rows=3 width=29) (actual time=0.047..0.047 rows=3 loops=1)
                                            Output: "SysCallDirectionLcz"."Name", "SysCallDirectionLcz"."RecordId"
                                            Buckets: 1′024 (originally 1′024)  Batches: 1 (originally 1)  Memory Usage: 9kB
                                            Buffers: shared read=1
                                            ->  Seq Scan on public."SysCallDirectionLcz"  (cost=0.00..1.65 rows=3 width=29) (actual time=0.031..0.035 rows=3 loops=1)
                                                  Output: "SysCallDirectionLcz"."Name", "SysCallDirectionLcz"."RecordId"
                                                  Filter: ("SysCallDirectionLcz"."SysCultureId" = '1a778e3f-0a8e-e111-84a3-00155d054c03'::uuid)
                                                  Rows Removed by Filter: 49
                                                  Buffers: shared read=1
                                ->  Hash  (cost=12.00..12.00 rows=200 width=53) (actual time=0.187..0.187 rows=155 loops=1)
                                      Output: "Contact"."Name", "Contact"."PhotoId", "Contact"."Id"
                                      Buckets: 1′024 (originally 1′024)  Batches: 1 (originally 1)  Memory Usage: 19kB
                                      Buffers: shared hit=10
                                      ->  Seq Scan on public."Contact"  (cost=0.00..12.00 rows=200 width=53) (actual time=0.016..0.131 rows=155 loops=1)
                                            Output: "Contact"."Name", "Contact"."PhotoId", "Contact"."Id"
                                            Buffers: shared hit=10
                          ->  Memoize  (cost=0.15..2.57 rows=1 width=53) (actual time=0.001..0.001 rows=0 loops=20)
                                Output: "GoOwner"."Name", "GoOwner"."PhotoId", "GoOwner"."Id"
                                Cache Key: "Call"."GoOwnerId"
                                Cache Mode: logical
                                Hits: 19  Misses: 1  Evictions: 0  Overflows: 0  Memory Usage: 1kB
                                ->  Index Scan using "PKDR5ErUGy8HVE2ImrX39YL4VU" on public."Contact" "GoOwner"  (cost=0.14..2.56 rows=1 width=53) (actual time=0.012..0.012 rows=0 loops=1)
                                      Output: "GoOwner"."Name", "GoOwner"."PhotoId", "GoOwner"."Id"
                                      Index Cond: ("GoOwner"."Id" = "Call"."GoOwnerId")
                    ->  Materialize  (cost=4.44..9.76 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=20)
                          Output: "GoBusinessCall"."GoCallId"
                          Buffers: shared read=1
                          ->  Nested Loop Semi Join  (cost=4.44..9.76 rows=1 width=16) (actual time=0.036..0.038 rows=0 loops=1)
                                Output: "GoBusinessCall"."GoCallId"
                                Buffers: shared read=1
                                ->  Seq Scan on public."GoBusinessCall"  (cost=0.00..1.34 rows=1 width=32) (actual time=0.035..0.036 rows=0 loops=1)
                                      Output: "GoBusinessCall"."Id", "GoBusinessCall"."CreatedOn", "GoBusinessCall"."CreatedById", "GoBusinessCall"."ModifiedOn", "GoBusinessCall"."ModifiedById", "GoBusinessCall"."ProcessListeners", "GoBusinessCall"."GoCallId", "GoBusinessCall"."GoBusinessId"
                                      Filter: ("GoBusinessCall"."GoBusinessId" = '4899d92d-72ef-41d0-a93b-ec552b03ba6c'::uuid)
                                      Rows Removed by Filter: 31
                                      Buffers: shared read=1
                                ->  Nested Loop Semi Join  (cost=4.44..8.41 rows=1 width=16) (never executed)
                                      Output: "SysGoBusinessCallRight"."RecordId"
                                      ->  Bitmap Heap Scan on public."SysGoBusinessCallRight"  (cost=4.17..6.22 rows=1 width=32) (never executed)
                                            Output: "SysGoBusinessCallRight"."Id", "SysGoBusinessCallRight"."CreatedOn", "SysGoBusinessCallRight"."CreatedById", "SysGoBusinessCallRight"."ModifiedOn", "SysGoBusinessCallRight"."ModifiedById", "SysGoBusinessCallRight"."RecordId", "SysGoBusinessCallRight"."SysAdminUnitId", "SysGoBusinessCallRight"."Operation", "SysGoBusinessCallRight"."RightLevel", "SysGoBusinessCallRight"."Position", "SysGoBusinessCallRight"."SourceId"
                                            Recheck Cond: ("SysGoBusinessCallRight"."RecordId" = "GoBusinessCall"."Id")
                                            Filter: (("SysGoBusinessCallRight"."RightLevel" >= 1) AND ("SysGoBusinessCallRight"."Operation" = 0))
                                            ->  Bitmap Index Scan on "IhxuqDdVswhKFCojliMwG4MrgEFg"  (cost=0.00..4.17 rows=3 width=0) (never executed)
                                                  Index Cond: ("SysGoBusinessCallRight"."RecordId" = "GoBusinessCall"."Id")
                                      ->  Index Only Scan using "IX_SysAdminUnitId_RoleId" on public."SysAdminUnitInRole"  (cost=0.27..1.23 rows=1 width=16) (never executed)
                                            Output: "SysAdminUnitInRole"."SysAdminUnitId", "SysAdminUnitInRole"."SysAdminUnitRoleId"
                                            Index Cond: (("SysAdminUnitInRole"."SysAdminUnitId" = '32f455e5-3e6e-4741-9e5f-3472f46607a8'::uuid) AND ("SysAdminUnitInRole"."SysAdminUnitRoleId" = "SysGoBusinessCallRight"."SysAdminUnitId"))
                                            Heap Fetches: 0
              ->  Nested Loop Semi Join  (cost=0.42..2.63 rows=1 width=16) (never executed)
                    Output: "SysCallRight"."RecordId"
                    ->  Index Only Scan using "IszbVas3KCTcVeM6HuHjDNmHOC4" on public."SysCallRight"  (cost=0.14..1.19 rows=1 width=32) (never executed)
                          Output: "SysCallRight"."RecordId", "SysCallRight"."SysAdminUnitId", "SysCallRight"."Operation", "SysCallRight"."RightLevel"
                          Index Cond: (("SysCallRight"."RecordId" = "Call"."Id") AND ("SysCallRight"."Operation" = 0) AND ("SysCallRight"."RightLevel" >= 1))
                          Heap Fetches: 0
                    ->  Index Only Scan using "IX_SysAdminUnitId_RoleId" on public."SysAdminUnitInRole" "SysAdminUnitInRole_1"  (cost=0.27..0.86 rows=1 width=16) (never executed)
                          Output: "SysAdminUnitInRole_1"."SysAdminUnitId", "SysAdminUnitInRole_1"."SysAdminUnitRoleId"
                          Index Cond: (("SysAdminUnitInRole_1"."SysAdminUnitId" = '32f455e5-3e6e-4741-9e5f-3472f46607a8'::uuid) AND ("SysAdminUnitInRole_1"."SysAdminUnitRoleId" = "SysCallRight"."SysAdminUnitId"))
                          Heap Fetches: 0
Planning:
  Buffers: shared hit=19 read=3
Planning Time: 23.457 ms
Execution Time: 1.398 ms