explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e4do

Settings
# exclusive inclusive rows x rows loops node
1. 28.703 5,713.778 ↓ 1.4 61,170 1

Nested Loop Left Join (cost=38,890.70..116,000.51 rows=45,097 width=91) (actual time=5,303.352..5,713.778 rows=61,170 loops=1)

2. 110.520 5,501.565 ↓ 1.4 61,170 1

Hash Right Join (cost=38,890.28..54,817.98 rows=45,097 width=79) (actual time=5,303.333..5,501.565 rows=61,170 loops=1)

  • Hash Cond: (mk2.id_produkt = a.id)
3. 87.871 87.871 ↑ 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=0.012..87.871 rows=436,791 loops=1)

4. 25.036 5,303.174 ↓ 1.4 61,170 1

Hash (cost=37,797.57..37,797.57 rows=45,097 width=68) (actual time=5,303.174..5,303.174 rows=61,170 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 3431kB
5. 16.777 5,278.138 ↓ 1.4 61,170 1

Nested Loop (cost=5.92..37,797.57 rows=45,097 width=68) (actual time=4.282..5,278.138 rows=61,170 loops=1)

6. 0.111 0.111 ↑ 3.6 25 1

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

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

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

  • Recheck Cond: ((id_portfel = p.id_portfel) AND (id_bank = p.id_bank))
  • Heap Blocks: exact=21195
8. 5.725 5.725 ↓ 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=0.229..0.229 rows=2,447 loops=25)

  • Index Cond: ((id_portfel = p.id_portfel) AND (id_bank = p.id_bank))
9. 183.510 183.510 ↑ 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.003..0.003 rows=1 loops=61,170)

  • Index Cond: (id_produkt = a.id)
Planning time : 8.983 ms
Execution time : 5,747.458 ms