size of the partitions 300GB each

Query took time :
duration: 8770.352 ms  execute _PLAN0xb75f400: SELECT equIDSEQID, equID FROM s14equINFO WHERE serequIDSEQID=$1 limit 55

Manual execution:



SELECT equIDSEQID, equID FROM s14equINFO WHERE serequIDSEQID='33314571598' 


 Append  (cost=0.57..74.85 rows=19 width=79) (actual time=0.623..8.934 rows=1 loops=1)
   ->  Index Scan using s14equinfo_part16_serequidseqid_idx on s14equinfo_part16 s14equinfo_1  (cost=0.57..4.61 rows=1 width=79) (actual time=0.622..0.634 rows=1 loops=1)
         Index Cond: (serequidseqid = '33314571598'::bigint)
   ->  Index Scan using s14equinfo_part1_serequidseqid_idx on s14equinfo_part1 s14equinfo_2  (cost=0.57..4.61 rows=1 width=79) (actual time=0.557..0.557 rows=0 loops=1)
         Index Cond: (serequidseqid = '33314571598'::bigint)
   ->  Index Scan using s14equinfo_part2_serequidseqid_idx on s14equinfo_part2 s14equinfo_3  (cost=0.57..4.61 rows=1 width=79) (actual time=0.568..0.568 rows=0 loops=1)
         Index Cond: (serequidseqid = '33314571598'::bigint)
   ->  Index Scan using s14equinfo_part3_serequidseqid_idx on s14equinfo_part3 s14equinfo_4  (cost=0.57..4.61 rows=1 width=79) (actual time=0.702..0.702 rows=0 loops=1)
         Index Cond: (serequidseqid = '33314571598'::bigint)
   ->  Index Scan using s14equinfo_part4_serequidseqid_idx on s14equinfo_part4 s14equinfo_5  (cost=0.57..4.61 rows=1 width=79) (actual time=0.641..0.641 rows=0 loops=1)
         Index Cond: (serequidseqid = '33314571598'::bigint)
   ->  Index Scan using s14equinfo_part5_serequidseqid_idx on s14equinfo_part5 s14equinfo_6  (cost=0.57..4.61 rows=1 width=79) (actual time=0.524..0.524 rows=0 loops=1)
         Index Cond: (serequidseqid = '33314571598'::bigint)
   ->  Index Scan using s14equinfo_part6_serequidseqid_idx on s14equinfo_part6 s14equinfo_7  (cost=0.57..4.61 rows=1 width=79) (actual time=0.684..0.684 rows=0 loops=1)
         Index Cond: (serequidseqid = '33314571598'::bigint)
   ->  Index Scan using s14equinfo_part7_serequidseqid_idx on s14equinfo_part7 s14equinfo_8  (cost=0.57..4.61 rows=1 width=79) (actual time=0.514..0.514 rows=0 loops=1)
         Index Cond: (serequidseqid = '33314571598'::bigint)
   ->  Index Scan using s14equinfo_part8_serequidseqid_idx on s14equinfo_part8 s14equinfo_9  (cost=0.57..4.61 rows=1 width=79) (actual time=0.634..0.634 rows=0 loops=1)
         Index Cond: (serequidseqid = '33314571598'::bigint)
   ->  Index Scan using s14equinfo_part9_serequidseqid_idx on s14equinfo_part9 s14equinfo_10  (cost=0.57..4.61 rows=1 width=79) (actual time=0.395..0.395 rows=0 loops=1)
         Index Cond: (serequidseqid = '33314571598'::bigint)
   ->  Index Scan using s14equinfo_part10_serequidseqid_idx on s14equinfo_part10 s14equinfo_11  (cost=0.57..4.61 rows=1 width=79) (actual time=0.353..0.353 rows=0 loops=1)
         Index Cond: (serequidseqid = '33314571598'::bigint)
   ->  Index Scan using s14equinfo_part11_serequidseqid_idx on s14equinfo_part11 s14equinfo_12  (cost=0.57..4.61 rows=1 width=79) (actual time=0.557..0.557 rows=0 loops=1)
         Index Cond: (serequidseqid = '33314571598'::bigint)
   ->  Index Scan using s14equinfo_part12_serequidseqid_idx on s14equinfo_part12 s14equinfo_13  (cost=0.57..5.38 rows=4 width=79) (actual time=0.662..0.662 rows=0 loops=1)
         Index Cond: (serequidseqid = '33314571598'::bigint)
   ->  Index Scan using s14equinfo_part13_serequidseqid_idx on s14equinfo_part13 s14equinfo_14  (cost=0.57..4.61 rows=1 width=79) (actual time=0.479..0.479 rows=0 loops=1)
         Index Cond: (serequidseqid = '33314571598'::bigint)
   ->  Index Scan using s14equinfo_part14_serequidseqid_idx on s14equinfo_part14 s14equinfo_15  (cost=0.57..4.61 rows=1 width=79) (actual time=0.518..0.518 rows=0 loops=1)
         Index Cond: (serequidseqid = '33314571598'::bigint)
   ->  Index Scan using s14equinfo_part15_serequidseqid_idx on s14equinfo_part15 s14equinfo_16  (cost=0.57..4.61 rows=1 width=79) (actual time=0.508..0.508 rows=0 loops=1)
         Index Cond: (serequidseqid = '33314571598'::bigint)
 Planning Time: 135.602 ms
 Execution Time: 9.045 ms
(35 rows)

Table structure:

\d+ s14equINFO
                                                     Partitioned table "s1.s14equinfo"
        Column        |            Type             | Collation | Nullable |    Default     | Storage  | Compression | Stats target | Description
----------------------+-----------------------------+-----------+----------+----------------+----------+-------------+--------------+-------------
 equidseqid        | bigint                      |           | not null |                | plain    |             |              |
 equid             | character varying(128)      |           | not null |                | extended |             |              |
 version              | integer                     |           | not null |                | plain    |             |              |
 expirytime           | integer                     |           | not null |                | plain    |             |              |
 dtcreated            | timestamp without time zone |           | not null | LOCALTIMESTAMP | plain    |             |              |
 equcapabilities   | character varying(10)       |           | not null |                | extended |             |              |
 equauthconfirmed  | character varying(1)        |           | not null |                | extended |             |              |
 equsignature      | character varying(4000)     |           |          |                | extended |             |              |
 equsiglength      | integer                     |           |          |                | plain    |             |              |
 equsigversion     | character varying(10)       |           |          |                | extended |             |              |
 clientipaddress      | numeric(32,0)               |           |          |                | main     |             |              |
 instanceid           | integer                     |           | not null |                | plain    |             |              |
 txid                 | bigint                      |           | not null |                | plain    |             |              |
 dtobserved           | timestamp without time zone |           | not null | LOCALTIMESTAMP | plain    |             |              |
 shortequsignature | character varying(512)      |           |          |                | extended |             |              |
 equtype           | integer                     |           |          |                | plain    |             |              |
 equidstatus       | integer                     |           |          |                | plain    |             |              |
 mfpfontinfo          | character varying(4000)     |           |          |                | extended |             |              |
 mfpfontinfoext1      | character varying(4000)     |           |          |                | extended |             |              |
 mfpfontinfoext2      | character varying(4000)     |           |          |                | extended |             |              |
 os                   | character varying(64)       |           |          |                | extended |             |              |
 browser              | character varying(64)       |           |          |                | extended |             |              |
 serequidseqid  | bigint                      |           |          |                | plain    |             |              |
Partition key: HASH (equidseqid)
Indexes:
    "s14equinfo_pkey" PRIMARY KEY, btree (equidseqid)
    "ser_s14equinfo_idx" btree (serequidseqid)
Publications:
    "p1_to_p2_all_table_pub"
Partitions: s14equinfo_part1 FOR VALUES WITH (modulus 16, remainder 1),
            s14equinfo_part10 FOR VALUES WITH (modulus 16, remainder 10),
            s14equinfo_part11 FOR VALUES WITH (modulus 16, remainder 11),
            s14equinfo_part12 FOR VALUES WITH (modulus 16, remainder 12),
            s14equinfo_part13 FOR VALUES WITH (modulus 16, remainder 13),
            s14equinfo_part14 FOR VALUES WITH (modulus 16, remainder 14),
            s14equinfo_part15 FOR VALUES WITH (modulus 16, remainder 15),
            s14equinfo_part16 FOR VALUES WITH (modulus 16, remainder 0),
            s14equinfo_part2 FOR VALUES WITH (modulus 16, remainder 2),
            s14equinfo_part3 FOR VALUES WITH (modulus 16, remainder 3),
            s14equinfo_part4 FOR VALUES WITH (modulus 16, remainder 4),
            s14equinfo_part5 FOR VALUES WITH (modulus 16, remainder 5),
            s14equinfo_part6 FOR VALUES WITH (modulus 16, remainder 6),
            s14equinfo_part7 FOR VALUES WITH (modulus 16, remainder 7),
            s14equinfo_part8 FOR VALUES WITH (modulus 16, remainder 8),
            s14equinfo_part9 FOR VALUES WITH (modulus 16, remainder 9)
