| NO |
missing_fk_indexes |
Missing foreign key indexes detected: order_items.order_id,
menu_items.restaurant_id,
reservations.customer_id,
orders.table_id. |
| NO |
missing_fk_constraints |
Missing foreign key constraints detected: order_items.order_id,
menu_items.restaurant_id,
reservations.customer_id,
tables.restaurant_id,
orders.table_id. |
| NO |
random_page_cost |
The db is using the default 'random_page_cost' value of '4'. This value is often too low for modern hardware and can result in suboptimal indexes utilization. Consider setting it to '1.1'. See https://pgtune.leopard.in.ua/ for more information. |
| NO |
work_mem |
The db is using the default 'work_mem' value of '4096kB'. This value is often too low for modern hardware and can result in suboptimal query plans. Visit https://pgtune.leopard.in.ua/ to find the correct value for your database. |
| NO |
table_cache_hit |
Table hit ratio is too low: 0.970186. |
| YES |
index_cache_hit |
Index hit ratio is correct: 0.999104. |
| NO |
unused_indexes |
Unused indexes detected:
'idx_customers_email' on 'public.customers' size 19 MB,
'idx_tables_restaurant_availability' on 'public.tables' size 8096 kB,
'idx_reservations_table_id' on 'public.reservations' size 15 MB,
'idx_reservations_date_time' on 'public.reservations' size 5432 kB |
| YES |
null_indexes |
No null indexes detected. |
| NO |
duplicate_indexes |
Duplicate indexes detected:
'customers_email_key' of size 39 MB is identical to 'idx_customers_email' |
| YES |
outliers |
No queries using significant execution ratio detected. |
| NO |
ssl_used |
Database client is using an unencrypted connection. |