explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DmUP

Settings
# exclusive inclusive rows x rows loops node
1. 73.052 9,667.973 ↑ 1.0 1 1

Aggregate (cost=24,344.48..24,344.49 rows=1 width=8) (actual time=9,667.972..9,667.973 rows=1 loops=1)

2. 9,351.482 9,594.921 ↓ 208.8 625,327 1

Bitmap Heap Scan on events_org_part_199 e (cost=429.64..24,336.99 rows=2,995 width=0) (actual time=273.911..9,594.921 rows=625,327 loops=1)

  • Recheck Cond: (recipients @> ANY ('{""[{\""id\"": \""cf0a5a7a-de07-4bd1-b038-4f83223a1f61\""}]"",""[{\""id\"": \""4409430d-1664-49f5-b6d8-9bd22d9da037\""}]""}'::jsonb[]))
  • Rows Removed by Index Recheck: 1477456
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND (created > '2019-10-01 00:00:00+00'::timestamp with time zone) AND (organization_uuid = 'fcb0b139-ed68-4220-a7a6-7e56e8214519'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 657434
  • Heap Blocks: exact=120474 lossy=396829
3. 243.439 243.439 ↓ 81.5 1,335,385 1

Bitmap Index Scan on events_org_part_199_recipients_idx (cost=0.00..428.90 rows=16,386 width=0) (actual time=243.439..243.439 rows=1,335,385 loops=1)

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