explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qmeb

Settings
# exclusive inclusive rows x rows loops node
1. 12.657 642.168 ↑ 3.2 21,329 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 8.897 629.511 ↑ 4.0 7,110 3 / 3

Nested Loop (cost=258,097.02..336,681.15 rows=28,115 width=273) (actual time=389.492..629.511 rows=7,110 loops=3)

3. 136.153 606.395 ↑ 4.0 7,110 3 / 3

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

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

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

5. 82.177 388.227 ↓ 1.3 168,023 3 / 3

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

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

  • Recheck Cond: (creationdate >= '2019-02-01'::date)
  • Heap Blocks: exact=63282
7. 18.892 18.892 ↑ 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.677..56.677 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: (id = eps.invoice_id)
Planning time : 0.693 ms
Execution time : 647.524 ms