explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aOXO

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 3,878.886 ↑ 1.0 1 1

Limit (cost=38,955.67..38,955.79 rows=1 width=17) (actual time=3,878.420..3,878.886 rows=1 loops=1)

2. 0.817 3,878.882 ↑ 1,948.0 1 1

Gather Merge (cost=38,955.67..39,182.95 rows=1,948 width=17) (actual time=3,878.418..3,878.882 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
3. 6.992 3,878.065 ↑ 974.0 1 1

Sort (cost=37,955.65..37,958.08 rows=974 width=17) (actual time=3,878.064..3,878.065 rows=1 loops=1)

  • Sort Key: (COALESCE(oao.is_primary, false)) DESC, oao.source_effective_date DESC, oao.id DESC
  • Sort Method: quicksort Memory: 583kB
4. 11.162 3,871.073 ↓ 5.1 4,996 1

Nested Loop (cost=148.03..37,907.30 rows=974 width=17) (actual time=12.344..3,871.073 rows=4,996 loops=1)

5. 678.750 690.263 ↓ 2.1 6,352 1

Parallel Bitmap Heap Scan on organization o (cost=147.60..19,074.24 rows=2,966 width=8) (actual time=12.224..690.263 rows=6,352 loops=1)

  • Recheck Cond: (merge_parent_id = 21550)
  • Heap Blocks: exact=3800
6. 11.513 11.513 ↑ 1.1 6,352 1

Bitmap Index Scan on organization_idx (cost=0.00..145.82 rows=7,119 width=0) (actual time=11.513..11.513 rows=6,352 loops=1)

  • Index Cond: (merge_parent_id = 21550)
7. 3,169.648 3,169.648 ↑ 1.0 1 6,352

Index Scan using organization_account_owner_org_idx2 on organization_account_owner oao (cost=0.43..6.34 rows=1 width=25) (actual time=0.491..0.499 rows=1 loops=6,352)

  • Index Cond: (organization_id = o.id)