explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fhcs

Settings
# exclusive inclusive rows x rows loops node
1. 158.468 64,077.611 ↑ 1.0 1 1

Aggregate (cost=24,223.83..24,223.84 rows=1 width=8) (actual time=64,077.610..64,077.611 rows=1 loops=1)

2. 63,681.595 63,919.143 ↓ 114.7 625,321 1

Bitmap Heap Scan on events_org_part_199 e (cost=425.76..24,210.20 rows=5,454 width=0) (actual time=272.906..63,919.143 rows=625,321 loops=1)

  • Recheck Cond: (recipients @> ANY ('{""[{\""id\"": \""cf0a5a7a-de07-4bd1-b038-4f83223a1f61\""}]"",""[{\""id\"": \""4409430d-1664-49f5-b6d8-9bd22d9da037\""}]""}'::jsonb[]))
  • Rows Removed by Index Recheck: 1477419
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND (organization_uuid = 'fcb0b139-ed68-4220-a7a6-7e56e8214519'::uuid))
  • Rows Removed by Filter: 657428
  • Heap Blocks: exact=120467 lossy=396829
3. 237.548 237.548 ↓ 81.5 1,335,367 1

Bitmap Index Scan on events_org_part_199_recipients_idx (cost=0.00..424.39 rows=16,386 width=0) (actual time=237.547..237.548 rows=1,335,367 loops=1)

  • Index Cond: (recipients @> ANY ('{""[{\""id\"": \""cf0a5a7a-de07-4bd1-b038-4f83223a1f61\""}]"",""[{\""id\"": \""4409430d-1664-49f5-b6d8-9bd22d9da037\""}]""}'::jsonb[]))
Planning time : 2.107 ms
Execution time : 64,078.481 ms