Select statement Running slow intermittently on Partitioned table

Hi Team,

We have a table "auditreference" on our PRODUCTION environment.

This table will be partitioned on a daily basis and everyday's audit data will be stored in that day's partitions.

These partitions will be there in database for 90 days and post that it will be truncated.

We have noticed that the select statement is running very slow on an intermittent basis on the partitions of this table.

Below is the table Description:

                Table "myschema.auditrtailreference"

          Column          |            Type             | Modifiers

--------------------------+-----------------------------+-----------

event                    | smallint                    |

innodeid                 | character varying(80)       |

innodename               | character varying(80)       |

sourceid                 | character varying(300)      |

intime                   | timestamp without time zone |

outnodeid                | character varying(80)       |