explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R6gq

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 8.795 ↑ 1.0 1 1

Finalize Aggregate (cost=10,403.71..10,403.72 rows=1 width=8) (actual time=8.794..8.795 rows=1 loops=1)

2. 10.957 11.152 ↓ 2.0 2 1

Gather (cost=10,403.60..10,403.71 rows=1 width=8) (actual time=0.860..11.152 rows=2 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 0.003 0.195 ↑ 1.0 1 2

Partial Aggregate (cost=9,403.60..9,403.61 rows=1 width=8) (actual time=0.195..0.195 rows=1 loops=2)

4. 0.001 0.192 ↓ 0.0 0 2

Nested Loop (cost=58.27..9,402.41 rows=476 width=8) (actual time=0.192..0.192 rows=0 loops=2)

5. 0.174 0.191 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on recipients r (cost=57.85..4,230.12 rows=1,739 width=8) (actual time=0.191..0.191 rows=0 loops=2)

  • Recheck Cond: ((org_id = '202600'::bigint) AND (deleted_id = '-1'::integer))
6. 0.017 0.017 ↓ 0.0 0 1

Bitmap Index Scan on idx_recipient_org_ek_nd (cost=0.00..57.11 rows=2,957 width=0) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (org_id = '202600'::bigint)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using persons_pk on persons p (cost=0.42..2.97 rows=1 width=16) (never executed)

  • Index Cond: (person_id = r.recipient_id)