CREATE OR REPLACE FUNCTION extract_crashing_functions (processed_json jsonb) RETURNS text AS

$$

    -- extract threads[crashing_idx]->frames[*]->function

    SELECT string_agg(functions, E'\n')

    FROM (

        SELECT jsonb_array_elements(

            (($1 #> ARRAY['threads', $1->'crash_info'->>'crashing_thread'])->'frames')

        )->>'function' AS functions

    ) AS frames

$$

LANGUAGE sql IMMUTABLE;

-- This extension is the contrib modules

CREATE EXTENSION IF NOT EXISTS pg_trgm;

-- Used for searching function in the crashing thread backtrace

-- Search will be really slow if this index is not present

CREATE INDEX crash_report_datas_idx_extract_crashing_functions ON crash_report_datas USING gist (

    extract_crashing_functions(processed) gist_trgm_ops

);