explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FbkA

Settings
# exclusive inclusive rows x rows loops node
1. 7.027 14.964 ↑ 465,542.0 1 1

Gather (cost=5,709.18..4,311,734.23 rows=465,542 width=132) (actual time=12.673..14.964 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.002 7.937 ↓ 0.0 0 3 / 3

Result (cost=4,709.18..4,264,180.03 rows=19,397,600 width=132) (actual time=7.937..7.937 rows=0 loops=3)

3. 0.012 7.935 ↓ 0.0 0 3 / 3

ProjectSet (cost=4,709.18..3,779,240.03 rows=19,397,600 width=1,154) (actual time=7.935..7.935 rows=0 loops=3)

4. 3.922 7.923 ↓ 0.0 0 3 / 3

Parallel Bitmap Heap Scan on pidsdata (cost=4,709.18..3,680,312.27 rows=193,976 width=1,122) (actual time=7.923..7.923 rows=0 loops=3)

  • Recheck Cond: (((bucket -> 'reli'::text) @> '[{"lpi": "9079269672"}]'::jsonb) OR ((bucket -> 'reli'::text) @> '[{"lli": "9079269672"}]'::jsonb))
  • Filter: (NOT deleted)
  • Heap Blocks: exact=237
5. 0.001 4.001 ↓ 0.0 0 1 / 3

BitmapOr (cost=4,709.18..4,709.18 rows=478,454 width=0) (actual time=12.003..12.003 rows=0 loops=1)

6. 2.023 2.023 ↑ 528.1 453 1 / 3

Bitmap Index Scan on reli_idx (cost=0.00..2,238.20 rows=239,227 width=0) (actual time=6.069..6.069 rows=453 loops=1)

  • Index Cond: ((bucket -> 'reli'::text) @> '[{"lpi": "9079269672"}]'::jsonb)
7. 1.977 1.977 ↑ 528.1 453 1 / 3

Bitmap Index Scan on reli_idx (cost=0.00..2,238.20 rows=239,227 width=0) (actual time=5.932..5.932 rows=453 loops=1)

  • Index Cond: ((bucket -> 'reli'::text) @> '[{"lli": "9079269672"}]'::jsonb)