explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gtNe

Settings
# exclusive inclusive rows x rows loops node
1. 963.875 4,228.418 ↑ 1.0 1,312,434 1

Hash Join (cost=129,751.07..485,893.83 rows=1,317,963 width=191) (actual time=1,845.097..4,228.418 rows=1,312,434 loops=1)

  • Output: t2.pe, t2.suma_naw_tw_siec_bud, t2.suma_naw_mk_siec_bud, t2.suma_naw_tw_siec_dzialka, t2.suma_naw_mk_siec_dzialka, t2.suma_liczba_ad, t2.instalacyjna_dlugosc_sieci, t2.suma_lin_nap_bud, t2.suma_lin_nap_mont, t2.suma_liczba_ad_rur, t2.suma_liczba_ad_slup, t2.suma_liczba_ad_kan, t3.pe, t3.rdcond
  • Hash Cond: ((t2.pe)::text = (t1.id_adres_pe1)::text)
  • Buffers: shared hit=349971
2. 1,248.667 2,521.248 ↑ 1.0 1,566,984 1

Hash Join (cost=50,118.90..392,910.86 rows=1,573,818 width=191) (actual time=1,092.072..2,521.248 rows=1,566,984 loops=1)

  • Output: t2.pe, t2.suma_naw_tw_siec_bud, t2.suma_naw_mk_siec_bud, t2.suma_naw_tw_siec_dzialka, t2.suma_naw_mk_siec_dzialka, t2.suma_liczba_ad, t2.instalacyjna_dlugosc_sieci, t2.suma_lin_nap_bud, t2.suma_lin_nap_mont, t2.suma_liczba_ad_rur, t2.suma_liczba_ad_slup, t2.suma_liczba_ad_kan, t3.pe, t3.rdcond
  • Hash Cond: ((t2.pe)::text = (t3.pe)::text)
  • Buffers: shared hit=299993
3. 339.450 339.450 ↑ 1.8 1,567,018 1

Seq Scan on _matrix_test.koszty_instalacji_1 t2 (cost=0.00..313,130.85 rows=2,784,585 width=148) (actual time=144.326..339.450 rows=1,567,018 loops=1)

  • Output: t2.pe, t2.suma_naw_tw_siec_bud, t2.suma_naw_mk_siec_bud, t2.suma_naw_tw_siec_dzialka, t2.suma_naw_mk_siec_dzialka, t2.suma_liczba_ad, t2.instalacyjna_dlugosc_sieci, t2.suma_lin_nap_bud, t2.suma_lin_nap_mont, t2.suma_liczba_ad_rur, t2.suma_liczba_ad_slup, t2.suma_liczba_ad_kan
  • Buffers: shared hit=285285
4. 672.442 933.131 ↑ 1.0 1,573,818 1

Hash (cost=30,446.18..30,446.18 rows=1,573,818 width=43) (actual time=933.131..933.131 rows=1,573,818 loops=1)

  • Output: t3.pe, t3.rdcond
  • Buckets: 2097152 Batches: 1 Memory Usage: 133483kB
  • Buffers: shared hit=14708
5. 260.689 260.689 ↑ 1.0 1,573,818 1

Seq Scan on _matrix_test.m_pe_mapinfo_new t3 (cost=0.00..30,446.18 rows=1,573,818 width=43) (actual time=0.030..260.689 rows=1,573,818 loops=1)

  • Output: t3.pe, t3.rdcond
  • Buffers: shared hit=14708
6. 475.316 743.295 ↑ 1.0 1,312,457 1

Hash (cost=63,157.63..63,157.63 rows=1,317,963 width=39) (actual time=743.295..743.295 rows=1,312,457 loops=1)

  • Output: t1.id_adres_pe1
  • Buckets: 2097152 Batches: 1 Memory Usage: 107772kB
  • Buffers: shared hit=49978
7. 267.979 267.979 ↑ 1.0 1,312,457 1

Seq Scan on _matrix_test.baza_startowa t1 (cost=0.00..63,157.63 rows=1,317,963 width=39) (actual time=0.035..267.979 rows=1,312,457 loops=1)

  • Output: t1.id_adres_pe1
  • Buffers: shared hit=49978