explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i23w

Settings
# exclusive inclusive rows x rows loops node
1. 12.540 641.314 ↑ 3.2 21,329 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 9.110 628.774 ↑ 4.0 7,110 3 / 3

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

3. 137.926 605.445 ↑ 4.0 7,110 3 / 3

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

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

5. 81.461 386.922 ↓ 1.3 168,023 3 / 3

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

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

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

Bitmap Index Scan on earlypaymentsettlement_creationdate_idx (cost=0.00..9,556.69 rows=517,368 width=0) (actual time=56.814..56.814 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.593 ms
Execution time : 646.737 ms