explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oMq8

Settings
# exclusive inclusive rows x rows loops node
1. 12.359 649.968 ↑ 3.2 21,329 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 9.165 637.609 ↑ 4.0 7,110 3 / 3

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

3. 136.314 614.225 ↑ 4.0 7,110 3 / 3

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

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

5. 83.039 395.475 ↓ 1.3 168,023 3 / 3

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

  • Buckets: 524288 Batches: 1 Memory Usage: 27776kB
6. 292.428 312.436 ↓ 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=109.192..312.436 rows=168,023 loops=3)

  • Recheck Cond: (creationdate >= '2019-02-01'::date)
  • Heap Blocks: exact=62736
7. 20.008 20.008 ↑ 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=60.025..60.025 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.660 ms
Execution time : 655.630 ms