explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cwf

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 104.660 ↓ 0.0 0 1

Limit (cost=1,009.31..52,211.68 rows=1 width=4) (actual time=96.432..104.660 rows=0 loops=1)

2. 0.001 104.658 ↓ 0.0 0 1

Nested Loop (cost=1,009.31..52,211.68 rows=1 width=4) (actual time=96.431..104.658 rows=0 loops=1)

  • Join Filter: (cbld.budget_detail_id = abd.id)
3. 0.001 104.657 ↓ 0.0 0 1

Nested Loop (cost=1,009.31..52,176.26 rows=1 width=4) (actual time=96.431..104.657 rows=0 loops=1)

4. 11.300 104.656 ↓ 0.0 0 1

Gather (cost=1,008.88..52,175.69 rows=1 width=4) (actual time=96.431..104.656 rows=0 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
5. 0.002 93.356 ↓ 0.0 0 5 / 5

Nested Loop (cost=8.88..51,175.59 rows=1 width=4) (actual time=93.354..93.356 rows=0 loops=5)

6. 44.195 93.332 ↑ 2.0 1 5 / 5

Hash Join (cost=8.45..51,174.56 rows=2 width=8) (actual time=90.127..93.332 rows=1 loops=5)

  • Hash Cond: (ail.account_analytic_id = aa.id)
7. 49.084 49.084 ↑ 1.3 382,991 5 / 5

Parallel Seq Scan on account_invoice_line ail (cost=0.00..49,909.39 rows=478,739 width=12) (actual time=0.011..49.084 rows=382,991 loops=5)

8. 0.005 0.053 ↑ 1.0 1 5 / 5

Hash (cost=8.44..8.44 rows=1 width=4) (actual time=0.052..0.053 rows=1 loops=5)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
9. 0.048 0.048 ↑ 1.0 1 5 / 5

Index Scan using account_analytic_account_code_idx on account_analytic_account aa (cost=0.42..8.44 rows=1 width=4) (actual time=0.048..0.048 rows=1 loops=5)

  • Index Cond: ((code)::text = 'M2000215'::text)
10. 0.022 0.022 ↓ 0.0 0 3 / 5

Index Scan using account_invoice_pkey on account_invoice iv (cost=0.42..0.52 rows=1 width=4) (actual time=0.036..0.036 rows=0 loops=3)

  • Index Cond: (id = ail.invoice_id)
  • Filter: (ltrim(rtrim((number)::text)) = 'FAANG00125C'::text)
  • Rows Removed by Filter: 1
11. 0.000 0.000 ↓ 0.0 0

Index Scan using crossovered_budget_lines_detail_pkey on crossovered_budget_lines_detail cbld (cost=0.43..0.57 rows=1 width=8) (never executed)

  • Index Cond: (id = ail.budget_detail_id)
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on affair_budget_detail abd (cost=0.00..21.30 rows=1,130 width=8) (never executed)

Planning time : 0.685 ms
Execution time : 104.701 ms