explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pFsc

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 3,016.355 ↑ 1.0 1 1

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

2. 0.930 3,016.348 ↑ 1,948.0 1 1

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

  • Workers Planned: 2
  • Workers Launched: 0
3. 6.493 3,015.418 ↑ 974.0 1 1

Sort (cost=37,955.65..37,958.08 rows=974 width=17) (actual time=3,015.418..3,015.418 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. 13.154 3,008.925 ↓ 5.1 4,996 1

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

5. 384.358 442.267 ↓ 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=58.608..442.267 rows=6,352 loops=1)

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

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

  • Index Cond: (merge_parent_id = 21550)
7. 2,553.504 2,553.504 ↑ 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.402..0.402 rows=1 loops=6,352)

  • Index Cond: (organization_id = o.id)