explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5sLN

Settings
# exclusive inclusive rows x rows loops node
1. 1,242.783 1,242.783 ↓ 374,755.0 374,755 1

Seq Scan on product_kv (cost=0.00..78,072.24 rows=1 width=16) (actual time=0.030..1,242.783 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