explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Mnf

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

Nested Loop (cost=1,000.87..24,872.47 rows=1,685 width=273) (actual time=21.225..21.226 rows=0 loops=1)

2. 3.899 22.461 ↓ 0.0 0 1

Gather (cost=1,000.87..24,850.15 rows=337 width=273) (actual time=21.224..22.461 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.001 18.562 ↓ 0.0 0 3 / 3

Nested Loop (cost=0.86..23,816.45 rows=140 width=273) (actual time=18.561..18.562 rows=0 loops=3)

4. 0.002 18.561 ↓ 0.0 0 3 / 3

Nested Loop (cost=0.43..23,472.84 rows=140 width=8) (actual time=18.560..18.561 rows=0 loops=3)

5. 18.559 18.559 ↓ 0.0 0 3 / 3

Parallel Seq Scan on apfearlypaymentsettlement ps_apfeps (cost=0.00..9,624.74 rows=1,732 width=16) (actual time=18.559..18.559 rows=0 loops=3)

  • Filter: (id = apfda_id)
  • Rows Removed by Filter: 277103
6. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using earlypaymentsettlement_pkey on earlypaymentsettlement eps (cost=0.43..8.00 rows=1 width=16) (never executed)

  • Index Cond: (id = ps_apfeps.id)
  • Filter: (creationdate = '2019-02-01'::date)
7. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using supplierinvoice_pkey on supplierinvoice si (cost=0.43..2.45 rows=1 width=273) (never executed)

  • Index Cond: (id = eps.invoice_id)
8. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.27 rows=5 width=0) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Seq Scan on apfdebtoragreement ps_apfeps_t_apfda (cost=0.00..1.25 rows=5 width=0) (never executed)

  • Filter: (bank_id = 3053)
Planning time : 0.778 ms
Execution time : 22.534 ms