explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6vSN

Settings
# exclusive inclusive rows x rows loops node
1. 27.372 3,571.439 ↓ 1.3 61,170 1

Nested Loop Left Join (cost=38,928.40..118,254.26 rows=46,667 width=91) (actual time=151.016..3,571.439 rows=61,170 loops=1)

2. 117.727 363.227 ↓ 1.3 61,170 1

Hash Right Join (cost=38,927.98..54,889.23 rows=46,667 width=79) (actual time=143.381..363.227 rows=61,170 loops=1)

  • Hash Cond: (mk2.id_produkt = a.id)
3. 107.171 107.171 ↑ 1.0 436,791 1

Seq Scan on an_t_saldo_pocz_cesja mk2 (cost=0.00..9,047.91 rows=436,791 width=15) (actual time=4.672..107.171 rows=436,791 loops=1)

4. 16.522 138.329 ↓ 1.3 61,170 1

Hash (cost=37,797.64..37,797.64 rows=46,667 width=68) (actual time=138.329..138.329 rows=61,170 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 3431kB
5. 14.603 121.807 ↓ 1.3 61,170 1

Nested Loop (cost=5.92..37,797.64 rows=46,667 width=68) (actual time=28.841..121.807 rows=61,170 loops=1)

6. 6.354 6.354 ↑ 3.6 25 1

Seq Scan on an_v_pakiety p (cost=0.00..12.88 rows=91 width=60) (actual time=6.294..6.354 rows=25 loops=1)

  • Filter: (sektor = 'Bank'::text)
  • Rows Removed by Filter: 38
7. 53.025 100.850 ↓ 15.8 2,447 25

Bitmap Heap Scan on bp_produkt a (cost=5.92..413.67 rows=155 width=24) (actual time=2.002..4.034 rows=2,447 loops=25)

  • Recheck Cond: ((id_portfel = p.id_portfel) AND (id_bank = p.id_bank))
  • Heap Blocks: exact=21170
8. 47.825 47.825 ↓ 15.8 2,447 25

Bitmap Index Scan on idxbp_produkt_id_portfel_id_bank (cost=0.00..5.88 rows=155 width=0) (actual time=1.913..1.913 rows=2,447 loops=25)

  • Index Cond: ((id_portfel = p.id_portfel) AND (id_bank = p.id_bank))
9. 3,180.840 3,180.840 ↑ 1.0 1 61,170

Index Scan using idxbp_zadluzenie_id_produkt on bp_zadluzenie za (cost=0.42..1.35 rows=1 width=20) (actual time=0.052..0.052 rows=1 loops=61,170)

  • Index Cond: (id_produkt = a.id)
Planning time : 118.053 ms
Execution time : 3,610.995 ms