explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0S7S

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

Unique (cost=68,601,008.61..70,942,719.09 rows=187,336,838 width=56) (actual rows= loops=)

  • Functions: 22
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
2. 0.000 0.000 ↓ 0.0

Sort (cost=68,601,008.61..69,069,350.71 rows=187,336,838 width=56) (actual rows= loops=)

  • Sort Key: h.id, mvi.telefon_numarasi, mvi.silindimi, mvi.telefon_tipi
3. 0.000 0.000 ↓ 0.0

Gather (cost=5,795,386.68..36,456,817.77 rows=187,336,838 width=56) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=5,794,386.68..17,722,133.97 rows=78,057,016 width=56) (actual rows= loops=)

  • Hash Cond: (mvi.fk_hasta_id = mi.hasta_id)
5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on vatandas_iletisim mvi (cost=0.00..4,137,046.25 rows=78,202,459 width=52) (actual rows= loops=)

  • Filter: ((telefon_numarasi ~ '[2-5]{1}\d{9}'::text) AND (telefon_tipi = ANY ('{1,2,3,4,5}'::bigint[])))
6. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=5,173,317.34..5,173,317.34 rows=35,728,907 width=12) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=2,121,683.40..5,173,317.34 rows=35,728,907 width=12) (actual rows= loops=)

  • Hash Cond: (mi.usoid = h.old_id)
8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on vatandas mi (cost=0.00..2,433,646.80 rows=35,795,480 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=1,500,614.07..1,500,614.07 rows=35,728,907 width=12) (actual rows= loops=)

  • -> Parallel Seq Scan on hasta h (cost=0.00..1500614.07 rows=35,728,907 width=12)JIT: