Firbase performance


#1

My fhirbasey transactions are getting slower . I have around 2.8 million records in my observation table and i am trying to update 10 records out of 2.8 million using transaction . Its taking around 3-4 minutes and its affecting my ui performance also. Can any one help me to solve this. I even tried to delete some of my records, even my deletes also is slower.


#2

Can you trace what exact sql statements are executed (turn on logging on pg side). Pretty sure - some index is missed.