explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FPJ7

Settings
# exclusive inclusive rows x rows loops node
1. 19.343 1,657.437 ↑ 8.3 85,408 1

Gather (cost=14,088.96..466,645.50 rows=706,451 width=273) (actual time=1,390.475..1,657.437 rows=85,408 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 25.969 1,638.094 ↑ 10.3 17,082 5 / 5

Nested Loop (cost=13,088.96..395,000.40 rows=176,613 width=273) (actual time=1,386.196..1,638.094 rows=17,082 loops=5)

3. 709.343 1,560.777 ↑ 10.3 17,116 5 / 5

Parallel Hash Join (cost=13,088.53..281,740.46 rows=176,670 width=8) (actual time=1,386.169..1,560.777 rows=17,116 loops=5)

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

Parallel Seq Scan on earlypaymentsettlement eps (cost=0.00..265,096.04 rows=1,354,624 width=16) (actual time=0.006..671.633 rows=1,084,962 loops=5)

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

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

  • Buckets: 1048576 Batches: 1 Memory Usage: 40768kB
6. 69.836 69.836 ↑ 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.005..69.836 rows=166,262 loops=5)

7. 51.348 51.348 ↑ 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.003..0.003 rows=1 loops=85,580)

  • Index Cond: (id = eps.invoice_id)
  • Filter: (nettingbundle_id IS NULL)
  • Rows Removed by Filter: 0
Planning time : 0.588 ms
Execution time : 1,680.186 ms