explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 899U

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 0.120 ↓ 0.0 1 1

Filter: json_contains(cast(json_extract(t1.f1,_utf8mb4'$[*]') as binary(30) array),json'["base64:type15:AQ=="]') (cost=0.71 rows=1) (cost=0..0 rows=0 width=0) (actual time=0.102..0.120 rows=1 loops=1)

2. 0.086 0.086 ↓ 0.0 1 1

Index range scan on t1 using i1 (cost=0.71 rows=1) (cost=0..0 rows=0 width=0) (actual time=0.077..0.086 rows=1 loops=1)