explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OoVe

Settings
# exclusive inclusive rows x rows loops node
1. 2.166 22.902 ↑ 1.0 1 1

Aggregate (cost=13,819.47..13,819.48 rows=1 width=8) (actual time=22.902..22.902 rows=1 loops=1)

2. 20.736 20.736 ↓ 1.6 42,930 1

Index Only Scan using ix_contacts_tags_associations_company_id_tag_id_contact_id on contacts_tags_associations (cost=0.56..13,750.76 rows=27,484 width=0) (actual time=0.176..20.736 rows=42,930 loops=1)

  • Index Cond: ((company_id = '\x4c2118ad54397f271b000000'::bytea) AND (tag_id = '\x4d34742ca9c639cd6d72740f'::bytea))
  • Heap Fetches: 42,930
Planning time : 0.415 ms
Execution time : 22.931 ms