explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZCZx

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

Gather Merge (cost=1,626,282.89..1,843,222.44 rows=1,859,352 width=159) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Sort (cost=1,625,282.87..1,627,607.06 rows=929,676 width=159) (actual rows= loops=)

  • Sort Key: t1.ad, t1.soyad
3. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=664,528.36..1,460,035.38 rows=929,676 width=159) (actual rows= loops=)

  • Hash Cond: (t0.id = t1.id)
4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on kisi t0 (cost=0.00..523,020.46 rows=12,693,543 width=47) (actual rows= loops=)

  • Filter: ((durum_id = '1'::numeric) AND (kisi_tipi_id = '1'::numeric))
5. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=636,418.65..636,418.65 rows=965,897 width=112) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on gercek_kisi t1 (cost=0.00..636,418.65 rows=965,897 width=112) (actual rows= loops=)