explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CwN6

Settings
# exclusive inclusive rows x rows loops node
1. 3.382 6.525 ↓ 5.5 299 1

Gather (cost=1,035.47..14,202.65 rows=54 width=273) (actual time=0.911..6.525 rows=299 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 0.187 3.143 ↓ 4.7 150 2 / 2

Nested Loop Left Join (cost=35.47..13,197.25 rows=32 width=273) (actual time=0.228..3.143 rows=150 loops=2)

3. 0.227 2.657 ↓ 4.7 150 2 / 2

Hash Join (cost=35.03..12,932.87 rows=32 width=8) (actual time=0.217..2.657 rows=150 loops=2)

  • Hash Cond: (ps_apfeps.apfda_id = ps_apfeps_t_apfda.id)
4. 0.382 2.411 ↓ 4.5 568 2 / 2

Nested Loop (cost=33.72..12,931.16 rows=127 width=16) (actual time=0.159..2.411 rows=568 loops=2)

5. 0.320 0.444 ↑ 1.2 792 2 / 2

Parallel Bitmap Heap Scan on earlypaymentsettlement eps (cost=33.30..6,257.58 rows=976 width=16) (actual time=0.147..0.444 rows=792 loops=2)

  • Recheck Cond: (creationdate = '2019-01-01'::date)
  • Heap Blocks: exact=47
6. 0.124 0.124 ↑ 1.0 1,585 1 / 2

Bitmap Index Scan on earlypaymentsettlement_creationdate_idx (cost=0.00..32.88 rows=1,660 width=0) (actual time=0.248..0.248 rows=1,585 loops=1)

  • Index Cond: (creationdate = '2019-01-01'::date)
7. 1.585 1.585 ↑ 1.0 1 1,585 / 2

Index Scan using apfearlypaymentsettlement_pkey on apfearlypaymentsettlement ps_apfeps (cost=0.42..6.84 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,585)

  • Index Cond: (id = eps.id)
8. 0.006 0.019 ↑ 1.0 5 2 / 2

Hash (cost=1.25..1.25 rows=5 width=8) (actual time=0.018..0.019 rows=5 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.013 0.013 ↑ 1.0 5 2 / 2

Seq Scan on apfdebtoragreement ps_apfeps_t_apfda (cost=0.00..1.25 rows=5 width=8) (actual time=0.009..0.013 rows=5 loops=2)

  • Filter: (bank_id = 3053)
  • Rows Removed by Filter: 15
10. 0.299 0.299 ↑ 1.0 1 299 / 2

Index Scan using supplierinvoice_pkey on supplierinvoice si (cost=0.43..8.26 rows=1 width=273) (actual time=0.002..0.002 rows=1 loops=299)

  • Index Cond: (eps.invoice_id = id)
Planning time : 0.739 ms
Execution time : 6.671 ms