explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sqOJ

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

Gather (cost=101,721,020.43..104,250,347.43 rows=232,888 width=132) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Result (cost=101,720,020.43..104,226,058.63 rows=9,703,700 width=132) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

ProjectSet (cost=101,720,020.43..103,983,466.13 rows=9,703,700 width=1,154) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on pidsdata (cost=101,720,020.43..103,933,977.26 rows=97,037 width=1,122) (actual rows= loops=)

  • Recheck Cond: ((bucket -> 'fsli'::text) @> '[{"lpi": "5058451353"}]'::jsonb)
  • Filter: (NOT deleted)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on fsli_idx (cost=0.00..101,719,962.20 rows=239,227 width=0) (actual rows= loops=)

  • Index Cond: ((bucket -> 'fsli'::text) @> '[{"lpi": "5058451353"}]'::jsonb)