WARNING: you don't own a lock of type RowExclusiveLock about lsm3 HOT 4 CLOSED

CREATE EXTENSION lsm3;

CREATE COLLATION case_insensitive
    (provider = icu, locale = 'en-US-u-ks-level2');

CREATE TABLE pings
(
    endpoint integer NOT NULL,
    server_time timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
    request_ip character varying(250) COLLATE case_insensitive NOT NULL,
    device_id uuid,
    client_time timestamp with time zone,
    session_start timestamp with time zone,
    serial_number character varying(250) COLLATE case_insensitive,
    local_ipv4 character varying(250) COLLATE case_insensitive,
    local_ipv6 character varying(250) COLLATE case_insensitive,
    latitude real,
    longitude real,
    accuracy real,
    location_age interval,
    email character varying(250) COLLATE case_insensitive
);

CREATE INDEX pings_accuracy_idx
    ON pings USING lsm3
    (endpoint ASC NULLS LAST, accuracy ASC NULLS LAST);

CREATE INDEX pings_client_time_idx
    ON pings USING brin
    (client_time);

CREATE INDEX pings_device_id_idx
    ON pings USING lsm3
    (endpoint ASC NULLS LAST, device_id ASC NULLS LAST, server_time DESC NULLS FIRST);

CREATE INDEX pings_email_idx
    ON pings USING lsm3
    (endpoint ASC NULLS LAST, email COLLATE case_insensitive ASC NULLS LAST, server_time DESC NULLS FIRST);

CREATE INDEX pings_latitude_idx
    ON pings USING lsm3
    (endpoint ASC NULLS LAST, latitude ASC NULLS LAST);

CREATE INDEX pings_local_ipv4_idx
    ON pings USING lsm3
    (endpoint ASC NULLS LAST, local_ipv4 ASC NULLS LAST, server_time DESC NULLS FIRST);

CREATE INDEX pings_local_ipv6_idx
    ON pings USING lsm3
    (endpoint ASC NULLS LAST, local_ipv6 ASC NULLS LAST, server_time DESC NULLS FIRST);

CREATE INDEX pings_location_age_idx
    ON pings USING lsm3
    (endpoint ASC NULLS LAST, location_age ASC NULLS LAST);

CREATE INDEX pings_longitude_idx
    ON pings USING lsm3
    (endpoint ASC NULLS LAST, longitude ASC NULLS LAST);

CREATE INDEX pings_request_ip_idx
    ON pings USING lsm3
    (endpoint ASC NULLS LAST, request_ip ASC NULLS LAST, server_time DESC NULLS FIRST);

CREATE INDEX pings_serial_number_idx
    ON pings USING lsm3
    (endpoint ASC NULLS LAST, serial_number COLLATE case_insensitive ASC NULLS LAST, server_time DESC NULLS FIRST);

CREATE INDEX pings_server_time_idx
    ON pings USING brin
    (server_time);

CREATE INDEX pings_session_start_idx
    ON pings USING lsm3
    (endpoint ASC NULLS LAST, session_start DESC NULLS FIRST, server_time DESC NULLS FIRST);