explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YxMd

Settings
# exclusive inclusive rows x rows loops node
1. 299.055 1,956.591 ↑ 8.3 427,900 1

Nested Loop (cost=14,088.96..511,041.03 rows=3,537,040 width=273) (actual time=1,404.448..1,956.591 rows=427,900 loops=1)

2. 0.000 1,571.956 ↑ 8.3 85,580 1

Gather (cost=14,088.96..466,826.77 rows=707,408 width=273) (actual time=1,404.435..1,571.956 rows=85,580 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 18.660 1,617.587 ↑ 10.3 17,116 5 / 5

Nested Loop (cost=13,088.96..395,085.97 rows=176,852 width=273) (actual time=1,399.740..1,617.587 rows=17,116 loops=5)

4. 687.581 1,564.695 ↑ 10.3 17,116 5 / 5

Parallel Hash Join (cost=13,088.53..281,744.18 rows=176,852 width=8) (actual time=1,399.715..1,564.695 rows=17,116 loops=5)

  • Hash Cond: (eps.id = ps_apfeps.id)
5. 692.586 692.586 ↑ 1.2 1,084,962 5 / 5

Parallel Seq Scan on earlypaymentsettlement eps (cost=0.00..265,096.10 rows=1,356,021 width=16) (actual time=0.007..692.586 rows=1,084,962 loops=5)

  • Filter: (creationdate >= '2019-01-01'::date)
  • Rows Removed by Filter: 189854
6. 108.486 184.528 ↑ 2.1 166,262 5 / 5

Parallel Hash (cost=8,758.79..8,758.79 rows=346,379 width=8) (actual time=184.528..184.528 rows=166,262 loops=5)

  • Buckets: 1048576 Batches: 1 Memory Usage: 40800kB
7. 76.042 76.042 ↑ 2.1 166,262 5 / 5

Parallel Seq Scan on apfearlypaymentsettlement ps_apfeps (cost=0.00..8,758.79 rows=346,379 width=8) (actual time=0.007..76.042 rows=166,262 loops=5)

8. 34.232 34.232 ↑ 1.0 1 85,580 / 5

Index Scan using supplierinvoice_pkey on supplierinvoice si (cost=0.43..0.64 rows=1 width=273) (actual time=0.002..0.002 rows=1 loops=85,580)

  • Index Cond: (id = eps.invoice_id)
9. 85.569 85.580 ↑ 1.0 5 85,580

Materialize (cost=0.00..1.27 rows=5 width=0) (actual time=0.000..0.001 rows=5 loops=85,580)

10. 0.011 0.011 ↑ 1.0 5 1

Seq Scan on apfdebtoragreement ps_apfeps_t_apfda (cost=0.00..1.25 rows=5 width=0) (actual time=0.008..0.011 rows=5 loops=1)

  • Filter: (bank_id = 3053)
  • Rows Removed by Filter: 15
Planning time : 0.666 ms
Execution time : 2,050.931 ms