PostgreSQL mQE

1. Function Executing as DEFINER User – Identifies functions with security definer.

2. Functions Written in C – Identifies functions that are written in C.

3. Unsupported AlloyDB Extension – Identifies the usage of extensions that are unsupported by AFPS.

1. AWS SCT Extension – Identifies the presence of the AWS SCT extension pack.

2. Large Object Data – Identifies the presence of the Large Object data type.

3. Max Database Size – Identifies when the maximum storage limit per cluster has been exceeded.

4. Read Replica as Source – Identifies the usage of a read replica as a source.

5. Trigger During Replication – Identifies triggers that are set to fire always, or on a replica.

6. Users and Roles – Identifies information about users and roles.

1. CPU Time % for query execution

2. Current allocated memory (Bytes)

3. Commit ratio

4. Extended Connections waiting for a lock

5. Maximum Transaction Age

6. Number Of rows INSERTED

7. Number Of rows UPDATED

8. Number Of rows DELETED

9. Number of queries

10. Transactions count

1. Physical Read IOPS

2. Physical Write IOPS

1. pg_bigm – Enables full text search and allows a two-gram (bigram) index for faster full text search.

2. refint – Enables the checking of foreign key restraints, the referencing table, and the referenced table.

3. decoderbufs – A logical decoder that delivers output data as Protocol Buffers, adapted for Debezium.

4. pg_wait_sample – Collects sampling statistics of wait events, providing wait event data for processes on servers.

1. Foreign Key Constraint

2. UNIQUE Constraint

3. CHECK Constraint

4. Block-range (BRIN) index

5. Generalized Inverted Index (GIN) 

6. GiST index

7. SP-GiST index

8. Hash index

9. Temporary Table

10. BTree Indexes

1. Big Integer Data Type – Identifies tables with Big Integer data type.
2. Big Serial Data Type – Identifies tables with Big Serial data type.
3. Bit String Data Type – Identifies tables with Bit String data type.
4. Boolean Data Type – Identifies tables with Boolean data type.
5. Box Data Type – Identifies tables with Box data type.
6. Character Data Types – Identifies tables with Character data type.
7. CIDR Data Type – Identifies tables with CIDR data type.
8. Circle Data Type – Identifies tables with Circle data type.
9. Date Data Type – Identifies tables with Date data type.
10. ARRAY Data Types – Identifies tables with ARRAY data types.
11. INET Data Type – Identifies tables with INET data type.
12. Integer Data Type – Identifies tables with Integer data type.
13. Small Integer Data Type – Identifies tables with Small Integer data type.
14. Small Serial Data Type – Identifies tables with Small Serial data type.
15. Serial Data Type – Identifies tables with Serial data type.
16. Interval Data Type – Identifies tables with Interval data type.
17. JSON Data Type – Identifies tables with JSON data type.
18. JSONB Data Type – Identifies tables with JSONB data type.
19. Line Data Type – Identifies tables with Line data type.
20. Line segments Data Type – Identifies tables with Line segments data type.
21. Mac address Data Type – Identifies tables with Mac address data type.
22. Monetary Data Type – Identifies tables with Monetary data type.
23. Numeric/Decimal Data Types – Identifies tables with Numeric/Decimal data types.
24. Path Data Type – Identifies tables with Path data type.
25. Log Sequence Number Data Type – Identifies tables with Log Sequence Number data type.
26. Point Data Type – Identifies tables with Point data type.
27. Polygon Data Type – Identifies tables with Polygon data type.
28. Real Data Type – Identifies tables with Real data type.
29. Time without time zone – Identifies tables with Time data type without time zone semantics.
30. Time with time zone – Identifies tables with Time data type containing time zone semantics.
31. Timestamp without time zone – Identifies tables with Timestamp data type without time zone semantics.
32. Timestamp with time zone – Identifies tables with Timestamp data type containing time zone semantics.
33. Text Search Data Types – Identifies tables with Text Search data types.
34. Txid Snapshot – Identifies tables with Txid Snapshot.
35. GUID/UUID Data Type – Identifies tables with GUID/UUID data type.
36. Multiranges Data Types – Identifies tables with Multiranges data types.
37. Range Data Types – Identifies tables with Range data types.
38. Enumerated Data Type – Identifies tables with Enumerated data type.
39. Object Identifier Type – Identifies tables with Object Identifier type.
40. Foreign Key Constraint – Identifies Foreign Key Constraint count.
41. UNIQUE Constraint – Identifies UNIQUE Constraint count.
42. CHECK Constraint – Identifies CHECK Constraint count.
43. Block-range (BRIN) index – Identifies Block-range (BRIN) index count.
44. Generalized Inverted Index (GIN) – Identifies Generalized Inverted Index (GIN) count.
45. GiST index – Identifies GiST index count.
46. SP-GiST index – Identifies SP-GiST index count.
47. Hash index – Identifies Hash index count.
48. ASC | DESC in View – Identifies view that is created with ASC | DESC.
49. UNION ALL in View – Identifies view that is created with UNION ALL.
50.ROW_NUMBER() Function in View – Identifies view that is created with ROW_NUMBER() function.
51. Data Encryption – Identifies view that is created with Data Encryption.
52. Decode() Function in View – Identifies view that is created with Decode() function.
53. Encode() Function in View – Identifies view that is created with Encode() function.
54. btrim String Function in View – Identifies view that is created with btrim String function.
55. greatest() Function in View – Identifies view that is created with greatest() function.
56. least() Function in View – Identifies view that is created with least() function.
57. now() Function in View – Identifies view that is created with now() function.
58. to_timestamp Function in View – Identifies view that is created with to_timestamp function.
59. bool_and Function in View – Identifies view that is created with bool_and function.
60. bool_or Function in View – Identifies view that is created with bool_or function.
61. every() Aggregate Function – Identifies view that is created with every() Aggregate function.
62. LATERAL Clause in View – Identifies view that is created with LATERAL Clause.
63. SEARCH Keyword in View – Identifies view that is created with SEARCH Keyword.
64. CYCLE Keyword in View – Identifies view that is created with CYCLE Keyword.
65. Database Links Extension – Identifies Database Links Extension.
66. Temporary Table – Identifies Temporary Table count.
67. GROUPING SETS support in View – Identifies view that is created with GROUPING SETS support.
68. CUBE support in View – Identifies view that is created with CUBE support.
69. ROLLUP support in View – Identifies view that is created with ROLLUP support.
70. NULLS FIRST/LAST in View – Identifies view that is created with NULLS FIRST/LAST.
71. WITHIN GROUP clause in View – Identifies view that is created with WITHIN GROUP clause.
72. WITH ORDINALITY clause in View – Identifies view that is created with WITH ORDINALITY clause.
73. Full Text Search in View – Identifies view that is created with Full Text Search.
74. WITH CHECK clause in View – Identifies view that is created with WITH CHECK clause.
75. SCRAM-SHA-256 Authentication – Identifies SCRAM-SHA-256 Authentication is enable or not.
76. SSL support – Identifies if SSL is enabled on the source database.
77. Databases per Instance – Identifies databases per instance count when it is more than 100.
78. Spanner View Count Limit – Identifies views per database count when it is more than 5000.
79. Spanner View Name Length Limit – Identifies views count where views name length are more than 128 characters.
80. Spanner Indexes per Database – Identifies indexes per database count when it is more than 10,000.
81. Spanner Indexes per Table – Identifies index count of each table and table name where index count is more than 32 in each table.
82. Spanner Index Name Length – Identifies index count when index name length is more than 128 characters.
83. Spanner Tables per Database – Identifies tables per database count when it is more than 5000.
84. Spanner Table Name Length – Identifies tables count where tables name length are more than 128 characters.
85. Spanner Columns per Table – Identifies columns per table count when it is more than 1024 in table.
86. Spanner Column Name Length – Identifies columns count where columns name length are more than 128 characters.
87. Toast Tables – Identifies Toast Tables count.
88. Archive Mode – Identifies if archive_mode parameter is enabled.
89. Autovacuum – Identifies if autovacuum parameter is enabled.
90. Block Size – Identifies Block Size.
91. Incremental Sort – Identifies if enable_incremental_sort parameter is enabled. The parameter enables or disables the query planner's use of incremental sort steps.
92. Maximum Index keys number – Identifies Maximum Index keys number.
93. Maximum Identifier length – Identifies Maximum Identifier length.
94. Installed PostgreSQL Extension – Identifies Installed PostgreSQL extension.
95. Spanner Index Key Size – Identifies tables and index key total size where it is greater than 8k.
96. Spanner Columns Per Index Key – Identifies table name where the number of indexed columns more than 16.
97. Spanner Columns Per Table Key – Identifies table name where the number of primary key and foreign key columns more than 16.

1. max_parallel_maintenance_workers – Sets the maximum number of parallel workers that can be started by a single utility command.
2. max_parallel_workers – Sets the maximum number of workers that the system can support for parallel operations.
3. max_parallel_workers_per_gather – Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
4. max_pred_locks_per_transaction – Controls the average number of object locks allocated for each transaction.
5. wal_receiver_timeout – Flag, ends replication connections that are inactive for the specified time.
6. wal_sender_timeout – Flag, which is for detection by the ending server, ends replication connections that are inactive for the specified time.

1. Azure unsupported Extension – Identifies if the source database has installed extensions which are not supported by Azure DB PostgreSQL.

2. Azure unsupported language – Identifies if the source database has installed languages which are not supported by Azure DB PostgreSQL.

1. auto_explain – Enables you to automatically log execution plans of slow statements, for troubleshooting and more. Provides an automated way to perform the functionality of the EXPLAIN command.

2. pg_cron – A cron-based job scheduler, this extension enables cron syntax to schedule commands from a database.

3. pg_hint_plan – Enables you to improve PostgreSQL execution plans using hints, which are simple descriptions in SQL comments.

4. pg_proctab – Enables you to use pg_top with Cloud SQL for PostgreSQL, and generate reports from the operating system process table.

1. Tables without PK – Identifies tables that do not have Primary Key constraints.

2. PG version lower 9.6 – Identifies if the database version is lower than 9.6.

3. Postgres Database not present – Identifies if source database has PostgreSQL database, which is a prerequisite for GCP DMS service.

4. pglogical extension missing – Identifies if pglogical extension is missing, which is required for logical replication setup.

1. huge_pages – Enables/disables the use of huge memory pages. Valid values are: try (default), on, off.

2. shared_buffers – Sets the amount of memory the database server uses for shared memory buffers.

3. wal_buffers – The amount of shared memory used for WAL data that has not yet been written to disk.

1. tcp_keepalives_count – Specifies the number of TCP keepalives that can be lost before the server's connection to the client is considered dead.

2. tcp_keepalives_idle – Specifies the number of seconds of inactivity after which TCP should send a keepalive message to the client.

3. tcp_keepalives_interval – Specifies the number of seconds after which a TCP keepalive message that is not acknowledged by the client should be retransmitted.

1. Tables without PK – Identifies tables which do not have Primary Key constraint.

2. PG version lower 9.6 – Identifies if database version is lower than 9.6.

3. Postgres Database not present – Identifies if source database has postgres database, which is a prerequisite for GCP DMS service.

4. pglogical extension missing – Identifies if pglogical extension is missing, which is required for logical replication setup.

5. GCP DMS parameters incorrect settings – Identifies if source database parameters meet GCP DMS service prerequisites.