High latency with supabase client

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
-- Create tableCREATE TABLE your_table_name (    id UUID PRIMARY KEY,    column1 TEXT,    column2 INT,    column3 BOOLEAN);-- Insert statementsINSERT INTO your_table_name (id, column1, column2, column3) VALUES    (uuid_generate_v4(), 'value1', 10, TRUE),    (uuid_generate_v4(), 'value2', 20, FALSE),    (uuid_generate_v4(), 'value3', 15, TRUE),    (uuid_generate_v4(), 'value4', 8, FALSE),    (uuid_generate_v4(), 'value5', 25, TRUE),    (uuid_generate_v4(), 'value6', 12, FALSE),    (uuid_generate_v4(), 'value7', 18, TRUE),    (uuid_generate_v4(), 'value8', 30, FALSE),    (uuid_generate_v4(), 'value9', 22, TRUE),    (uuid_generate_v4(), 'value10', 5, FALSE),    (uuid_generate_v4(), 'value11', 17, TRUE),    (uuid_generate_v4(), 'value12', 9, FALSE),    (uuid_generate_v4(), 'value13', 14, TRUE),    (uuid_generate_v4(), 'value14', 28, FALSE),    (uuid_generate_v4(), 'value15', 11, TRUE),    (uuid_generate_v4(), 'value16', 7, FALSE),    (uuid_generate_v4(), 'value17', 19, TRUE),    (uuid_generate_v4(), 'value18', 26, FALSE),    (uuid_generate_v4(), 'value19', 16, TRUE),    (uuid_generate_v4(), 'value20', 21, FALSE);

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
import timefrom supabase import Client, create_clientimport psycopgdef psycop_call(): #user_ids: list[str]):    user="YOUR_SUPABASE_USER"    password="YOUR_SUPABASE_PASSWORD"    host="SUPABASE_HOST"    port=5432    database="postgres"    with psycopg.connect(f"host={host} port={port} dbname={database} user={user} password={password}") as conn:        # Open a cursor to perform database operations        results = []        with conn.cursor() as cur:            start = time.time()            # Execute a command: this creates a new table            cur.execute("SELECT * FROM public.your_table_name")            cur.fetchall()            for record in cur:                results.append(record)            stop = time.time()            return (stop - start)def supabase_call():    supabase: Client = create_client("SUPABASE_URL", "SUPBASE_SERVICE_ROLE_KEY")    start = time.time()    result = supabase.table("your_table_name").select("*").execute()    stop = time.time()    return (stop - start)if __name__ == "__main__":    ref = psycop_call()    sup = supabase_call()    print(f"postgres: {ref}, supabase: {sup}, ratio: {sup/ref}")