explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M4jk

Settings
# exclusive inclusive rows x rows loops node
1. 13.730 650.939 ↑ 3.2 21,329 1

Gather (cost=259,098.47..344,519.54 rows=67,475 width=273) (actual time=386.997..650.939 rows=21,329 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 5.623 637.209 ↑ 4.0 7,110 3 / 3

Hash Join (cost=258,098.47..336,772.04 rows=28,115 width=273) (actual time=384.406..637.209 rows=7,110 loops=3)

  • Hash Cond: (ps_apfeps.apfda_id = ps_apfeps_t_apfda.id)
3. 9.287 631.562 ↑ 4.0 7,110 3 / 3

Nested Loop (cost=258,097.02..336,681.15 rows=28,115 width=281) (actual time=384.338..631.562 rows=7,110 loops=3)

4. 143.286 608.056 ↑ 4.0 7,110 3 / 3

Parallel Hash Join (cost=258,096.58..267,764.62 rows=28,115 width=16) (actual time=384.308..608.056 rows=7,110 loops=3)

  • Hash Cond: (ps_apfeps.id = eps.id)
5. 81.646 81.646 ↑ 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.006..81.646 rows=277,103 loops=3)

6. 81.367 383.124 ↓ 1.3 168,023 3 / 3

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

  • Buckets: 524288 Batches: 1 Memory Usage: 27808kB
7. 283.599 301.757 ↓ 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=100.317..301.757 rows=168,023 loops=3)

  • Recheck Cond: (creationdate >= '2019-02-01'::date)
  • Heap Blocks: exact=62853
8. 18.158 18.158 ↑ 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=54.473..54.473 rows=504,070 loops=1)

  • Index Cond: (creationdate >= '2019-02-01'::date)
9. 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: (id = eps.invoice_id)
10. 0.009 0.024 ↑ 1.0 20 3 / 3

Hash (cost=1.20..1.20 rows=20 width=8) (actual time=0.024..0.024 rows=20 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.015 0.015 ↑ 1.0 20 3 / 3

Seq Scan on apfdebtoragreement ps_apfeps_t_apfda (cost=0.00..1.20 rows=20 width=8) (actual time=0.010..0.015 rows=20 loops=3)

Planning time : 0.788 ms
Execution time : 656.298 ms