explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5ky3

Settings
# exclusive inclusive rows x rows loops node
1. 8.069 421.567 ↑ 8.2 21,486 1

Gather (cost=1,002.18..224,339.56 rows=176,613 width=273) (actual time=0.619..421.567 rows=21,486 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 10.819 413.498 ↑ 10.3 7,162 3 / 3

Nested Loop (cost=2.18..205,678.26 rows=73,589 width=273) (actual time=0.097..413.498 rows=7,162 loops=3)

3. 63.521 388.321 ↑ 10.3 7,179 3 / 3

Nested Loop (cost=1.75..158,486.94 rows=73,612 width=8) (actual time=0.084..388.321 rows=7,179 loops=3)

4. 109.978 186.179 ↑ 1.2 69,311 3 / 3

Hash Join (cost=1.31..9,862.02 rows=86,595 width=8) (actual time=0.064..186.179 rows=69,311 loops=3)

  • Hash Cond: (ps_apfeps.apfda_id = ps_apfeps_t_apfda.id)
5. 76.184 76.184 ↑ 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.003..76.184 rows=277,103 loops=3)

6. 0.006 0.017 ↑ 1.0 5 3 / 3

Hash (cost=1.25..1.25 rows=5 width=8) (actual time=0.016..0.017 rows=5 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.011 0.011 ↑ 1.0 5 3 / 3

Seq Scan on apfdebtoragreement ps_apfeps_t_apfda (cost=0.00..1.25 rows=5 width=8) (actual time=0.008..0.011 rows=5 loops=3)

  • Filter: (bank_id = 3053)
  • Rows Removed by Filter: 15
8. 138.621 138.621 ↓ 0.0 0 207,932 / 3

Index Scan using earlypaymentsettlement_pkey on earlypaymentsettlement eps (cost=0.43..1.72 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=207,932)

  • Index Cond: (id = ps_apfeps.id)
  • Filter: (creationdate >= '2019-01-01'::date)
  • Rows Removed by Filter: 1
9. 14.358 14.358 ↑ 1.0 1 21,537 / 3

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

  • Index Cond: (id = eps.invoice_id)
  • Filter: (nettingbundle_id IS NULL)
  • Rows Removed by Filter: 0
Planning time : 0.909 ms
Execution time : 427.109 ms