explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yUNO

Settings
# exclusive inclusive rows x rows loops node
1. 629.671 711.857 ↓ 1.0 172,117 1

Merge Join (cost=50.34..18,138.58 rows=169,584 width=13) (actual time=0.025..711.857 rows=172,117 loops=1)

  • Merge Cond: (("PC0".contactid)::text = (commoptions.ownerid)::text)
  • -> Index Scan using pa_communication_options_pk on pa_communication_options commoptions (cost=0.42..9922.37 rows=169584 width=13) (actual time=0.012..142
2. 82.186 82.186 ↓ 1.0 210,836 1

Index Only Scan using pa_contact_pk on pa_contact "PC0" (cost=0.42..5,577.10 rows=208,312 width=13) (actual time=0.009..82.186 rows=210,836 loops=1)

  • Heap Fetches: 77344
  • Index Cond: ((communicationid)::text = 'C'::text)
  • Filter: ((class)::text = 'PHONE'::text)
  • Rows Removed by Filter: 45593
Planning time : 0.313 ms
Execution time : 745.659 ms