explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3NCS

Settings
# exclusive inclusive rows x rows loops node
1. 154.659 353.541 ↑ 1.0 172,117 1

Merge Join (cost=0.84..15,302.23 rows=172,319 width=13) (actual time=0.033..353.541 rows=172,117 loops=1)

  • Merge Cond: (("PC0".contactid)::text = (commoptions.ownerid)::text)
2. 56.212 56.212 ↑ 1.0 210,836 1

Index Only Scan using pa_contact_idx1 on pa_contact "PC0" (cost=0.42..3,977.03 rows=210,841 width=13) (actual time=0.016..56.212 rows=210,836 loops=1)

  • Heap Fetches: 0
3. 142.670 142.670 ↑ 1.0 172,152 1

Index Scan using pa_communication_idx1 on pa_communication_options commoptions (cost=0.42..8,644.10 rows=172,319 width=13) (actual time=0.014..142.670 rows=172,152 loops=1)

  • Filter: (((communicationid)::text = 'C'::text) AND ((class)::text = 'PHONE'::text))
  • Rows Removed by Filter: 45682
Planning time : 0.369 ms
Execution time : 385.700 ms