explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vFcv

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1,001.41..545,172.81 rows=16 width=76) (actual rows= loops=)

  • Group Key: cn.id
  • Functions: 19
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
2. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=1,001.41..534,473.47 rows=534,959 width=92) (actual rows= loops=)

  • Merge Cond: (cn.id = o.complex_name_id)
3. 0.000 0.000 ↓ 0.0

Index Scan using complex_name_pkey on complex_name cn (cost=0.14..12.38 rows=16 width=60) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=1,001.28..527,774.06 rows=534,959 width=36) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Gather Merge (cost=1,001.28..526,436.67 rows=534,959 width=36) (actual rows= loops=)

  • Workers Planned: 1
6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.27..465,253.77 rows=314,682 width=36) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.71..72,375.01 rows=15,317 width=14) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Parallel Index Scan using organization_complex_name_id_index on organization o (cost=0.29..4,929.88 rows=15,317 width=13) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Only Scan using companies_pkey on companies c (cost=0.42..4.40 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (tin = o.tin)
10. 0.000 0.000 ↓ 0.0

Index Scan using transactions_company_tin_index on transactions t (cost=0.56..22.37 rows=328 width=32) (actual rows= loops=)

  • Index Cond: (company_tin = c.tin)
  • Filter: (active AND action)