HTML
SOURCE
QUERY
REFORMATTED QUERY
COMMENTS
STATS

#	exclusive	inclusive	rows x	rows	loops	node
1.	15.113	100.041	↓ 1.1	3,322	1	→ Gather (cost=1,000.00..14,029.83 rows=3,110 width=163) (actual time=0.254..100.041 rows=3,322 loops=1) Workers Planned: 2 Workers Launched: 2
2.	84.928	84.928	↑ 1.2	3,321 - 292,902	3 / 3	→ Parallel Seq Scan on transactions t0 (cost=0.00..12,718.83 rows=1,296 width=163) (actual time=53.861..84.928 rows=1,107 loops=3) Filter: ("references"[2] = '(USER,53)'::transaction_reference) Rows Removed by Filter: 97,634

Planning time	:	0.105 ms
Execution time	:	100.180 ms

EXPLAIN ANALYZE SELECT t0.* FROM "transactions" AS t0 WHERE ("references"[2] = '(USER,53)'::transaction_reference);
                                                              QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
 Gather  (cost=1000.00..14029.83 rows=3110 width=163) (actual time=0.254..100.041 rows=3322 loops=1)
   Workers Planned: 2
   Workers Launched: 2
   ->  Parallel Seq Scan on transactions t0  (cost=0.00..12718.83 rows=1296 width=163) (actual time=53.861..84.928 rows=1107 loops=3)
         Filter: ("references"[2] = '(USER,53)'::transaction_reference)
         Rows Removed by Filter: 97634
 Planning Time: 0.105 ms
 Execution Time: 100.180 ms
(8 rows)


EXPLAIN ANALYZE SELECT t0.* FROM "transactions" AS t0 WHERE ("references"[2] = '(USER,53)'::transaction_reference);

EXPLAIN ANALYZE
SELECT
    t0.*
FROM
    transactions AS t0
WHERE
    references[2] = '(USER,53)'::transaction_reference;
-- Formatted by Pg::SQL::PrettyPrinter

\d transactions
                                          Table "public.transactions"
    Column     |            Type             | Collation | Nullable |                 Default
---------------+-----------------------------+-----------+----------+------------------------------------------
 id            | bigint                      |           | not null | nextval('transactions_id_seq'::regclass)
 site_id       | integer                     |           | not null |
 account_id    | bigint                      |           | not null |
 currency_code | global_currency_code        |           | not null |
 type          | transaction_type            |           | not null |
 references    | transaction_reference[]     |           | not null |
 amount        | numeric(28,12)              |           | not null |
 inserted_at   | timestamp without time zone |           | not null |
 updated_at    | timestamp without time zone |           | not null |
 main_ref_type | transaction_reference_type  |           |          |
 end_balance   | numeric(28,12)              |           |          |
Indexes:
    "transactions_pkey" PRIMARY KEY, btree (id)
    "transaction_site_id_references_user_offset_index" btree (site_id, ("references"[2]))
    "transactions_reference_gin" gin ("references")
Foreign-key constraints:
    "transactions_account_id_fkey" FOREIGN KEY (account_id) REFERENCES accounts(id)

Per node type stats

node type	count	sum of times	% of query
Gather	1	15.113 ms	15.1 %
Parallel Seq Scan	1	84.928 ms	84.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
transactions	1	84.928 ms	84.9 %
Parallel Seq Scan	1	84.928 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kd9L

Color mode:

Visible columns:

Per node type stats

Per table stats