explain.depesz.com

PostgreSQL's explain analyze made readable

Result: svAm

Settings
# exclusive inclusive rows x rows loops node
1. 213.654 437.158 ↑ 1.0 172,117 1

Hash Join (cost=6,612.55..16,771.44 rows=172,319 width=13) (actual time=125.108..437.158 rows=172,117 loops=1)

  • Hash Cond: ((commoptions.ownerid)::text = ("PC0".contactid)::text)
2. 98.531 98.531 ↑ 1.0 172,152 1

Seq Scan on pa_communication_options commoptions (cost=0.00..6,712.51 rows=172,319 width=13) (actual time=0.006..98.531 rows=172,152 loops=1)

  • Filter: (((communicationid)::text = 'C'::text) AND ((class)::text = 'PHONE'::text))
  • Rows Removed by Filter: 45682
3. 124.973 124.973 ↑ 1.0 210,841 1

Hash (cost=3,977.03..3,977.03 rows=210,841 width=13) (actual time=124.973..124.973 rows=210,841 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 9332kB
  • -> Index Only Scan using pa_contact_idx1 on pa_contact "PC0" (cost=0.42..3977.03 rows=210841 width=13) (actual time=0.017..53.699 rows=210841 loops