explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3NCS

Settings
# exclusive inclusive rows x rows loops node
1. 297.329 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)
  • -> Index Scan using pa_communication_idx1 on pa_communication_options commoptions (cost=0.42..8644.10 rows=172319 width=13) (actual time=0.014..142.670 r
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
  • 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