explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 573e : Optimization for: wfwaef; plan #UGfp

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=9,217.06..9,238.71 rows=8,661 width=211) (actual rows= loops=)

  • Sort Key: session_jsonb_ordered_ts_2.ts DESC
2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on session_jsonb_ordered_ts_2 (cost=89.32..8,650.62 rows=8,661 width=211) (actual rows= loops=)

  • Recheck Cond: ((attrs @> '{""mnf"": ""samsung""}'::jsonb) OR (attrs @> '{""os"": ""10.10.x""}'::jsonb))
  • Filter: ((ts >= '1575936000004'::bigint) AND (ts <= '1576799999991'::bigint))
3. 0.000 0.000 ↓ 0.0

BitmapOr (cost=89.32..89.32 rows=8,665 width=0) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on session_jsonb_ordered_ts_2_attrs_idx (cost=0.00..42.49 rows=4,333 width=0) (actual rows= loops=)

  • Index Cond: (attrs @> '{""mnf"": ""samsung""}'::jsonb)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on session_jsonb_ordered_ts_2_attrs_idx (cost=0.00..42.49 rows=4,333 width=0) (actual rows= loops=)

  • Index Cond: (attrs @> '{""os"": ""10.10.x""}'::jsonb)