explain.depesz.com

PostgreSQL's explain analyze made readable

Result: psIp

Settings
# exclusive inclusive rows x rows loops node
1. 3.280 6.447 ↓ 5.5 299 1

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

  • Workers Planned: 1
  • Workers Launched: 1
2. 0.207 3.167 ↓ 4.7 150 2 / 2

Nested Loop (cost=35.47..13,197.25 rows=32 width=273) (actual time=0.241..3.167 rows=150 loops=2)

3. 0.232 2.661 ↓ 4.7 150 2 / 2

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

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

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

5. 0.323 0.451 ↑ 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.150..0.451 rows=792 loops=2)

  • Recheck Cond: (creationdate = '2019-01-01'::date)
  • Heap Blocks: exact=49
6. 0.129 0.129 ↑ 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.257..0.257 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.007 0.020 ↑ 1.0 5 2 / 2

Hash (cost=1.25..1.25 rows=5 width=8) (actual time=0.019..0.020 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: (id = eps.invoice_id)
Planning time : 0.761 ms
Execution time : 6.613 ms