Search Postgresql Archives

Different result behavior when using ANY(ARRAY(SELECT)) and IN (SELECT)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi everyone,
I'm encountering some problems in understanding the behavior of a query that uses an IN operator, the query i'm executing is the following:

SELECT * FROM   (
              SELECT _id,
                     ROW_NUMBER() OVER () AS _rownumber
              FROM   (
                              SELECT   "Id"                _id,
                                       "IdClass"::regclass _idclass,
                                       "CurrentId"         _currentid,
                                       "User"              _user,
                                       "BeginDate"         _begindate,
                                       "EndDate"           _enddate,
                                       "Status"            _status,
                                       "Code"              _code,
                                       "Description"       _description
                              FROM     "Hardware" _hardware
                              WHERE    "IdClass" = ANY (ARRAY[...])
                              AND      "Id" IN (
                                       (
                                              SELECT "Id"
                                              FROM   "Hardware"
                                              WHERE  "Status" = 'A'
                                              AND    "IdClass" NOT IN ('"NetEquipment"'::regclass,
                                                                       '"Battery"'::regclass,
                                                                       '"DistribBoard"'::regclass,
                                                                       '"Termination"'::regclass,
                                                                       '"SysEquipment"'::regclass) ))
                              AND      "IdClass" = ANY (ARRAY[...])
                              AND      "Status" = 'A'
                              ORDER BY _code ASC) _rdinner) _rdouther
WHERE  _id = 64297639;

I've excluded the content of the arrays because it would have been too much useless text;
When executing this query i'm expecting a single result with the row number of the record and its Id but instead i'm obtaining different results at every execution, here the results of 3 sequential executions:
* 1) 64297639;2490
       64297639;20867
* 2) 64297639;2484
       64297639;14683
* 3) 64297639;2511
       64297639;20844
After researching a bit on the internet I've found people that were encountering some issues with the usage of the IN operator and solved the problem by switching it to an ANY(ARRAY()), so i've changed the following part of the query:
AND      "Id" IN (
                                       (
                                              SELECT "Id"
                                              FROM   "Hardware"
                                              WHERE  "Status" = 'A'
                                              AND    "IdClass" NOT IN ('"NetEquipment"'::regclass,
                                                                       '"Battery"'::regclass,
                                                                       '"DistribBoard"'::regclass,
                                                                       '"Termination"'::regclass,
                                                                       '"SysEquipment"'::regclass) ))

to this one:

AND      "Id" = ANY ( ARRAY (
                                              SELECT "Id"
                                              FROM   "Hardware"
                                              WHERE  "Status" = 'A'
                                              AND    "IdClass" NOT IN ('"NetEquipment"'::regclass,
                                                                       '"Battery"'::regclass,
                                                                       '"DistribBoard"'::regclass,
                                                                       '"Termination"'::regclass,
                                                                       '"SysEquipment"'::regclass) ))
In this case the result of the whole query is what i'm expecting and it's consistent at every execution:
64297639;2211
To try and understand the difference between the two queries i've tried using the EXPLAIN ANALYZE and this is the result:

* Query with IN operator:

"Subquery Scan on _rdouther  (cost=9285.49..11035.69 rows=1 width=16) (actual time=26.841..41.850 rows=2 loops=1)"
"  Filter: (_rdouther._id = 64297639)"
"  Rows Removed by Filter: 27138"
"  ->  WindowAgg  (cost=9285.49..10889.84 rows=11668 width=16) (actual time=25.156..40.675 rows=27140 loops=1)"
"        ->  Subquery Scan on _rdinner  (cost=9285.49..10743.99 rows=11668 width=8) (actual time=25.153..34.801 rows=27140 loops=1)"
"              ->  Gather Merge  (cost=9285.49..10627.31 rows=11668 width=815) (actual time=25.152..32.900 rows=27140 loops=1)"
"                    Workers Planned: 1"
"                    Workers Launched: 1"
"                    ->  Sort  (cost=8285.48..8314.65 rows=11668 width=815) (actual time=18.988..19.671 rows=13570 loops=2)"
"                          Sort Key: _hardware."Code""
"                          Sort Method: quicksort  Memory: 1717kB"
"                          ->  Hash Semi Join  (cost=1408.19..3307.79 rows=11668 width=815) (actual time=8.489..15.665 rows=13570 loops=2)"
"                                Hash Cond: (_hardware."Id" = "Hardware"."Id")"
"                                ->  Append  (cost=0.00..1739.09 rows=11673 width=45) (actual time=0.009..4.489 rows=13570 loops=2)"
"                                      ->  Parallel Seq Scan on "Hardware" _hardware  (cost=0.00..0.00 rows=1 width=226) (actual time=0.000..0.000 rows=0 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "ServerHW" _hardware_1  (cost=0.00..0.00 rows=1 width=226) (actual time=0.000..0.000 rows=0 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "ClientHW" _hardware_2  (cost=0.00..0.00 rows=1 width=226) (actual time=0.000..0.000 rows=0 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "PhoneHW" _hardware_3  (cost=0.00..0.00 rows=1 width=226) (actual time=0.000..0.000 rows=0 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "Peripheral" _hardware_4  (cost=0.00..0.00 rows=1 width=226) (actual time=0.000..0.000 rows=0 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "RackDevice" _hardware_5  (cost=0.00..0.00 rows=1 width=226) (actual time=0.000..0.000 rows=0 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "BladeChassis" _hardware_6  (cost=0.00..1.72 rows=5 width=29) (actual time=0.003..0.006 rows=4 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                            Rows Removed by Filter: 4"
"                                      ->  Parallel Seq Scan on "NetworkDevice" _hardware_7  (cost=0.00..0.00 rows=1 width=226) (actual time=0.000..0.000 rows=0 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "Server" _hardware_8  (cost=0.00..0.00 rows=1 width=226) (actual time=0.000..0.000 rows=0 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "Storage" _hardware_9  (cost=0.00..6.36 rows=44 width=28) (actual time=0.006..0.022 rows=38 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "System" _hardware_10  (cost=0.00..51.42 rows=386 width=226) (actual time=0.001..0.131 rows=328 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "Computer" _hardware_11  (cost=0.00..0.00 rows=1 width=226) (actual time=0.000..0.000 rows=0 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "DesktopDevice" _hardware_12  (cost=0.00..0.00 rows=1 width=226) (actual time=0.000..0.000 rows=0 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "MobileDevice" _hardware_13  (cost=0.00..0.00 rows=1 width=226) (actual time=0.000..0.000 rows=0 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "TelephoneExchange" _hardware_14  (cost=0.00..0.00 rows=1 width=226) (actual time=0.000..0.000 rows=0 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "VideoconfSys" _hardware_15  (cost=0.00..4.24 rows=28 width=22) (actual time=0.001..0.012 rows=24 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                            Rows Removed by Filter: 1"
"                                      ->  Parallel Seq Scan on "Modem" _hardware_16  (cost=0.00..2.26 rows=16 width=34) (actual time=0.001..0.007 rows=14 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "Monitor" _hardware_17  (cost=0.00..1.13 rows=2 width=25) (actual time=0.001..0.002 rows=2 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "Printer" _hardware_18  (cost=0.00..0.00 rows=1 width=226) (actual time=0.000..0.000 rows=0 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "GenericRackDevice" _hardware_19  (cost=0.00..119.69 rows=920 width=36) (actual time=0.001..0.245 rows=782 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                            Rows Removed by Filter: 6"
"                                      ->  Parallel Index Scan using "_cm3_GenNetDevice_IdClass" on "GenNetDevice" _hardware_20  (cost=0.29..1107.31 rows=8209 width=34) (actual time=0.026..2.134 rows=10638 loops=2)"
"                                            Index Cond: ((("IdClass")::oid = ANY ('{96465301,96465566,96465630,96465816,96465833,96466039,96466123,96465257,96469940,96469949,96470011,96470031,96466031,96470133,96470003,96465825,96470242,96470323,96465273,9 (...)"
"                                      ->  Parallel Seq Scan on "TLCDevice" _hardware_21  (cost=0.00..22.67 rows=192 width=226) (actual time=0.004..0.088 rows=164 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "PhysicalServer" _hardware_22  (cost=0.00..26.66 rows=148 width=31) (actual time=0.003..0.059 rows=126 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                            Rows Removed by Filter: 4"
"                                      ->  Parallel Bitmap Heap Scan on "VirtualServer" _hardware_23  (cost=55.42..393.73 rows=1696 width=40) (actual time=0.262..0.995 rows=1442 loops=2)"
"                                            Recheck Cond: ("Status" = 'A'::bpchar)"
"                                            Filter: ((("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,96471011,96465816,96465281,96470 (...)"
"                                            Heap Blocks: exact=88"
"                                            ->  Bitmap Index Scan on "_cm3_VirtualServer_pk_tdb"  (cost=0.00..54.70 rows=2883 width=0) (actual time=0.208..0.208 rows=2883 loops=1)"
"                                      ->  Parallel Seq Scan on "Desktop" _hardware_24  (cost=0.00..1.90 rows=12 width=25) (actual time=0.002..0.005 rows=10 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "Mobile" _hardware_25  (cost=0.00..0.00 rows=1 width=226) (actual time=0.000..0.000 rows=0 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                      ->  Parallel Seq Scan on "Notebook" _hardware_26  (cost=0.00..0.00 rows=1 width=226) (actual time=0.000..0.000 rows=0 loops=2)"
"                                            Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,964 (...)"
"                                ->  Hash  (cost=1160.24..1160.24 rows=19836 width=8) (actual time=8.390..8.399 rows=19820 loops=2)"
"                                      Buckets: 32768  Batches: 1  Memory Usage: 1031kB"
"                                      ->  Append  (cost=0.00..1160.24 rows=19836 width=8) (actual time=0.019..6.308 rows=19820 loops=2)"
"                                            ->  Seq Scan on "Hardware"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "ServerHW"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "ClientHW"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "PhoneHW"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "Peripheral"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "RackDevice"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.003 rows=0 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "BladeChassis"  (cost=0.00..1.30 rows=9 width=8) (actual time=0.003..0.007 rows=9 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                                  Rows Removed by Filter: 7"
"                                            ->  Seq Scan on "NetworkDevice"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "Server"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "Storage"  (cost=0.00..4.41 rows=75 width=8) (actual time=0.004..0.021 rows=75 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "System"  (cost=0.00..34.30 rows=656 width=8) (actual time=0.006..0.155 rows=656 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "Computer"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "DesktopDevice"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "MobileDevice"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "SIM"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "TelephoneExchange"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "VideoconfSys"  (cost=0.00..2.94 rows=48 width=8) (actual time=0.003..0.014 rows=48 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                                  Rows Removed by Filter: 2"
"                                            ->  Seq Scan on "Modem"  (cost=0.00..1.53 rows=28 width=8) (actual time=0.004..0.009 rows=28 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "Monitor"  (cost=0.00..1.06 rows=3 width=8) (actual time=0.003..0.004 rows=3 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "Printer"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "GenericRackDevice"  (cost=0.00..78.55 rows=1564 width=8) (actual time=0.003..0.395 rows=1564 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                                  Rows Removed by Filter: 12"
"                                            ->  Seq Scan on "GenNetDevice"  (cost=0.00..790.24 rows=13956 width=8) (actual time=0.012..3.443 rows=13956 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                                  Rows Removed by Filter: 670"
"                                            ->  Seq Scan on "TLCDevice"  (cost=0.00..14.13 rows=327 width=8) (actual time=0.011..0.096 rows=327 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "PhysicalServer"  (cost=0.00..19.88 rows=251 width=8) (actual time=0.005..0.076 rows=251 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                                  Rows Removed by Filter: 9"
"                                            ->  Index Scan using "_cm3_VirtualServer_IdClass" on "VirtualServer"  (cost=0.28..210.55 rows=2883 width=8) (actual time=0.011..0.833 rows=2883 loops=2)"
"                                                  Filter: (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[]))"
"                                            ->  Seq Scan on "Desktop"  (cost=0.00..1.38 rows=20 width=8) (actual time=0.007..0.012 rows=20 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "Mobile"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.003 rows=0 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                            ->  Seq Scan on "Notebook"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=2)"
"                                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"Planning time: 20.293 ms"
"Execution time: 42.085 ms"

* Query with ANY ( ARRAY () ):

"Subquery Scan on _rdouther  (cost=1472.17..1476.34 rows=1 width=16) (actual time=104.068..110.576 rows=1 loops=1)"
"  Filter: (_rdouther._id = 64297639)"
"  Rows Removed by Filter: 19819"
"  ->  WindowAgg  (cost=1472.17..1474.95 rows=111 width=16) (actual time=103.262..109.804 rows=19820 loops=1)"
"        ->  Subquery Scan on _rdinner  (cost=1472.17..1473.56 rows=111 width=8) (actual time=103.257..105.829 rows=19820 loops=1)"
"              ->  Sort  (cost=1472.17..1472.45 rows=111 width=862) (actual time=103.257..104.234 rows=19820 loops=1)"
"                    Sort Key: _hardware."Code""
"                    Sort Method: quicksort  Memory: 1774kB"
"                    InitPlan 1 (returns $0)"
"                      ->  Append  (cost=0.00..1160.24 rows=19836 width=8) (actual time=0.006..5.594 rows=19820 loops=1)"
"                            ->  Seq Scan on "Hardware"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "ServerHW"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "ClientHW"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "PhoneHW"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "Peripheral"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "RackDevice"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "BladeChassis"  (cost=0.00..1.30 rows=9 width=8) (actual time=0.002..0.006 rows=9 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                  Rows Removed by Filter: 7"
"                            ->  Seq Scan on "NetworkDevice"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "Server"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "Storage"  (cost=0.00..4.41 rows=75 width=8) (actual time=0.002..0.019 rows=75 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "System"  (cost=0.00..34.30 rows=656 width=8) (actual time=0.002..0.141 rows=656 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "Computer"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "DesktopDevice"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "MobileDevice"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "SIM"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "TelephoneExchange"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "VideoconfSys"  (cost=0.00..2.94 rows=48 width=8) (actual time=0.002..0.013 rows=48 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                  Rows Removed by Filter: 2"
"                            ->  Seq Scan on "Modem"  (cost=0.00..1.53 rows=28 width=8) (actual time=0.004..0.010 rows=28 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "Monitor"  (cost=0.00..1.06 rows=3 width=8) (actual time=0.002..0.002 rows=3 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "Printer"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "GenericRackDevice"  (cost=0.00..78.55 rows=1564 width=8) (actual time=0.002..0.337 rows=1564 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                  Rows Removed by Filter: 12"
"                            ->  Seq Scan on "GenNetDevice"  (cost=0.00..790.24 rows=13956 width=8) (actual time=0.002..3.084 rows=13956 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                  Rows Removed by Filter: 670"
"                            ->  Seq Scan on "TLCDevice"  (cost=0.00..14.13 rows=327 width=8) (actual time=0.004..0.070 rows=327 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "PhysicalServer"  (cost=0.00..19.88 rows=251 width=8) (actual time=0.003..0.064 rows=251 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                                  Rows Removed by Filter: 9"
"                            ->  Index Scan using "_cm3_VirtualServer_IdClass" on "VirtualServer"  (cost=0.28..210.55 rows=2883 width=8) (actual time=0.010..0.756 rows=2883 loops=1)"
"                                  Filter: (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[]))"
"                            ->  Seq Scan on "Desktop"  (cost=0.00..1.38 rows=20 width=8) (actual time=0.005..0.009 rows=20 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "Mobile"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                            ->  Seq Scan on "Notebook"  (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
"                                  Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid <> ALL ('{96470051,96465281,96465885,96471239,96471113}'::oid[])))"
"                    ->  Result  (cost=0.00..308.16 rows=111 width=862) (actual time=6.560..97.650 rows=19820 loops=1)"
"                          ->  Append  (cost=0.00..307.05 rows=111 width=92) (actual time=6.559..95.840 rows=19820 loops=1)"
"                                ->  Seq Scan on "Hardware" _hardware  (cost=0.00..0.00 rows=1 width=226) (actual time=0.002..0.002 rows=0 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Seq Scan on "ServerHW" _hardware_1  (cost=0.00..0.00 rows=1 width=226) (actual time=0.001..0.001 rows=0 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Seq Scan on "ClientHW" _hardware_2  (cost=0.00..0.00 rows=1 width=226) (actual time=0.001..0.001 rows=0 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Seq Scan on "PhoneHW" _hardware_3  (cost=0.00..0.00 rows=1 width=226) (actual time=0.001..0.001 rows=0 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Seq Scan on "Peripheral" _hardware_4  (cost=0.00..0.00 rows=1 width=226) (actual time=0.001..0.001 rows=0 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Seq Scan on "RackDevice" _hardware_5  (cost=0.00..0.00 rows=1 width=226) (actual time=0.001..0.001 rows=0 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Seq Scan on "BladeChassis" _hardware_6  (cost=0.00..2.42 rows=4 width=29) (actual time=6.552..6.557 rows=9 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                      Rows Removed by Filter: 7"
"                                ->  Seq Scan on "NetworkDevice" _hardware_7  (cost=0.00..0.00 rows=1 width=226) (actual time=0.002..0.002 rows=0 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Seq Scan on "Server" _hardware_8  (cost=0.00..0.00 rows=1 width=226) (actual time=0.001..0.001 rows=0 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Seq Scan on "Storage" _hardware_9  (cost=0.00..9.66 rows=9 width=28) (actual time=0.004..0.055 rows=75 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Bitmap Heap Scan on "System" _hardware_10  (cost=18.83..38.45 rows=10 width=226) (actual time=13.303..13.569 rows=656 loops=1)"
"                                      Recheck Cond: ("Id" = ANY ($0))"
"                                      Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,96471011, (...)"
"                                      Heap Blocks: exact=22"
"                                      ->  Bitmap Index Scan on "System_pkey"  (cost=0.00..18.82 rows=10 width=0) (actual time=13.294..13.295 rows=656 loops=1)"
"                                            Index Cond: ("Id" = ANY ($0))"
"                                ->  Seq Scan on "Computer" _hardware_11  (cost=0.00..0.00 rows=1 width=226) (actual time=0.002..0.002 rows=0 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Seq Scan on "DesktopDevice" _hardware_12  (cost=0.00..0.00 rows=1 width=226) (actual time=0.001..0.001 rows=0 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Seq Scan on "MobileDevice" _hardware_13  (cost=0.00..0.00 rows=1 width=226) (actual time=0.001..0.001 rows=0 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Seq Scan on "TelephoneExchange" _hardware_14  (cost=0.00..0.00 rows=1 width=226) (actual time=0.002..0.002 rows=0 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Seq Scan on "VideoconfSys" _hardware_15  (cost=0.00..6.44 rows=9 width=22) (actual time=0.007..0.233 rows=48 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                      Rows Removed by Filter: 2"
"                                ->  Seq Scan on "Modem" _hardware_16  (cost=0.00..3.48 rows=9 width=34) (actual time=0.008..0.141 rows=28 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Seq Scan on "Monitor" _hardware_17  (cost=0.00..1.27 rows=3 width=25) (actual time=0.007..0.018 rows=3 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Seq Scan on "Printer" _hardware_18  (cost=0.00..0.00 rows=1 width=226) (actual time=0.001..0.001 rows=0 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Bitmap Heap Scan on "GenericRackDevice" _hardware_19  (cost=26.85..54.19 rows=10 width=36) (actual time=14.192..14.695 rows=1564 loops=1)"
"                                      Recheck Cond: ("Id" = ANY ($0))"
"                                      Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,96471011, (...)"
"                                      Heap Blocks: exact=49"
"                                      ->  Bitmap Index Scan on "GenericRackDevice_pkey"  (cost=0.00..26.85 rows=10 width=0) (actual time=14.182..14.182 rows=1564 loops=1)"
"                                            Index Cond: ("Id" = ANY ($0))"
"                                ->  Bitmap Heap Scan on "GenNetDevice" _hardware_20  (cost=38.93..75.64 rows=10 width=34) (actual time=15.619..19.434 rows=13956 loops=1)"
"                                      Recheck Cond: ("Id" = ANY ($0))"
"                                      Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,96471011, (...)"
"                                      Heap Blocks: exact=516"
"                                      ->  Bitmap Index Scan on "GenNetDevice_pkey"  (cost=0.00..38.93 rows=10 width=0) (actual time=15.570..15.570 rows=13956 loops=1)"
"                                            Index Cond: ("Id" = ANY ($0))"
"                                ->  Bitmap Heap Scan on "TLCDevice" _hardware_21  (cost=9.55..18.80 rows=10 width=226) (actual time=10.329..10.485 rows=327 loops=1)"
"                                      Recheck Cond: ("Id" = ANY ($0))"
"                                      Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,96471011, (...)"
"                                      Heap Blocks: exact=8"
"                                      ->  Bitmap Index Scan on "TLCDevice_pkey"  (cost=0.00..9.55 rows=10 width=0) (actual time=10.317..10.317 rows=327 loops=1)"
"                                            Index Cond: ("Id" = ANY ($0))"
"                                ->  Bitmap Heap Scan on "PhysicalServer" _hardware_22  (cost=9.55..24.91 rows=9 width=31) (actual time=10.325..10.442 rows=251 loops=1)"
"                                      Recheck Cond: ("Id" = ANY ($0))"
"                                      Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,96471011, (...)"
"                                      Heap Blocks: exact=15"
"                                      ->  Bitmap Index Scan on "PhysicalServer_pkey"  (cost=0.00..9.55 rows=10 width=0) (actual time=10.317..10.317 rows=251 loops=1)"
"                                            Index Cond: ("Id" = ANY ($0))"
"                                ->  Index Scan using "VirtualServer_pkey" on "VirtualServer" _hardware_23  (cost=0.28..69.03 rows=5 width=40) (actual time=11.880..16.751 rows=2883 loops=1)"
"                                      Index Cond: ("Id" = ANY ($0))"
"                                      Filter: (("Status" = 'A'::bpchar) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469949,96471323,96471011, (...)"
"                                ->  Seq Scan on "Desktop" _hardware_24  (cost=0.00..2.77 rows=8 width=25) (actual time=0.119..2.330 rows=20 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Seq Scan on "Mobile" _hardware_25  (cost=0.00..0.00 rows=1 width=226) (actual time=0.002..0.002 rows=0 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"                                ->  Seq Scan on "Notebook" _hardware_26  (cost=0.00..0.00 rows=1 width=226) (actual time=0.002..0.002 rows=0 loops=1)"
"                                      Filter: (("Status" = 'A'::bpchar) AND ("Id" = ANY ($0)) AND (("IdClass")::oid = ANY ('{96466039,96471219,96465885,96470133,96471113,96471239,96470323,96469940,96470051,96471133,96471363,96466123,96470031,96465833,96469 (...)"
"Planning time: 17.877 ms"
"Execution time: 110.774 ms"

I've executed everything on postgres 10.14 and on postgres 9.5.23, encountering the same results.
What is the cause of the difference in the results? Could it be something related to the parallel sequence scan? Is this considerable a bug or am I missing something in the behavior of the operator?

Thanks in advance for any support.
Davide Jensen

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux