explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sKpm

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.85..11.75 rows=76 width=2,436) (actual rows= loops=)

  • Hash Cond: (oferty_przydzial_znizek.opz_znizka_kod = oferty_znizki.znizka_kod)
2. 0.000 0.000 ↓ 0.0

Seq Scan on oferty_przydzial_znizek (cost=0.00..7.48 rows=76 width=11) (actual rows= loops=)

  • Filter: (opz_oferta_kod = 1)
3. 0.000 0.000 ↓ 0.0

Hash (cost=2.52..2.52 rows=26 width=2,425) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on oferty_znizki (cost=0.00..2.52 rows=26 width=2,425) (actual rows= loops=)

  • Filter: ((znizka_m < 3) AND (znizka_blokada = 'f'::bpchar))