explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IV0f

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 2,291.728 ↓ 20.0 20 1

Limit (cost=78,181.30..78,181.31 rows=1 width=16) (actual time=2,291.711..2,291.728 rows=20 loops=1)

2. 142.416 2,291.720 ↓ 20.0 20 1

Sort (cost=78,181.30..78,181.31 rows=1 width=16) (actual time=2,291.710..2,291.720 rows=20 loops=1)

  • Sort Key: sort_name_base
  • Sort Method: top-N heapsort Memory: 25kB
3. 2,149.304 2,149.304 ↓ 374,755.0 374,755 1

Seq Scan on product_kv (cost=0.00..78,181.29 rows=1 width=16) (actual time=0.054..2,149.304 rows=374,755 loops=1)

  • Filter: ((flv @> '{"vis": true}'::jsonb) AND (div @> '{"key": [1]}'::jsonb) AND (flv @> '{"ava": true}'::jsonb) AND (nds @> '{"key": [1312]}'::jsonb) AND ((pls @> '{"key": [15]}'::jsonb) OR (pls @> '{"key": [139]}'::jsonb)) AND ((mks @> '{"key": [1]}'::jsonb) OR (mks @> '{"key": [-1]}'::jsonb)) AND ((ugs @> '{"key": [1]}'::jsonb) OR (ugs @> '{"key": [-1]}'::jsonb)))
  • Rows Removed by Filter: 393966