explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a5gR

Settings
# exclusive inclusive rows x rows loops node
1. 12.699 657.984 ↑ 3.2 21,329 1

Gather (cost=259,097.02..344,428.65 rows=67,475 width=273) (actual time=406.226..657.984 rows=21,329 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 9.080 645.285 ↑ 4.0 7,110 3 / 3

Nested Loop Left Join (cost=258,097.02..336,681.15 rows=28,115 width=273) (actual time=403.789..645.285 rows=7,110 loops=3)

3. 137.342 621.986 ↑ 4.0 7,110 3 / 3

Parallel Hash Join (cost=258,096.58..267,764.62 rows=28,115 width=8) (actual time=403.767..621.986 rows=7,110 loops=3)

  • Hash Cond: (ps_apfeps.id = eps.id)
4. 82.108 82.108 ↑ 1.3 277,103 3 / 3

Parallel Seq Scan on apfearlypaymentsettlement ps_apfeps (cost=0.00..8,758.79 rows=346,379 width=16) (actual time=0.005..82.108 rows=277,103 loops=3)

5. 83.504 402.536 ↓ 1.3 168,023 3 / 3

Parallel Hash (cost=256,479.81..256,479.81 rows=129,342 width=16) (actual time=402.536..402.536 rows=168,023 loops=3)

  • Buckets: 524288 Batches: 1 Memory Usage: 27776kB
6. 297.289 319.032 ↓ 1.3 168,023 3 / 3

Parallel Bitmap Heap Scan on earlypaymentsettlement eps (cost=9,686.03..256,479.81 rows=129,342 width=16) (actual time=112.309..319.032 rows=168,023 loops=3)

  • Recheck Cond: (creationdate >= '2019-02-01'::date)
  • Heap Blocks: exact=62841
7. 21.743 21.743 ↑ 1.0 504,070 1 / 3

Bitmap Index Scan on eps_creation_time_date_idx (cost=0.00..9,556.69 rows=517,368 width=0) (actual time=65.224..65.230 rows=504,070 loops=1)

  • Index Cond: (creationdate >= '2019-02-01'::date)
8. 14.219 14.219 ↑ 1.0 1 21,329 / 3

Index Scan using supplierinvoice_pkey on supplierinvoice si (cost=0.43..2.45 rows=1 width=273) (actual time=0.002..0.002 rows=1 loops=21,329)

  • Index Cond: (eps.invoice_id = id)
Planning time : 0.654 ms
Execution time : 663.307 ms