explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XJlC

Settings
# exclusive inclusive rows x rows loops node
1. 0.217 13.611 ↑ 1.0 1 1

Aggregate (cost=827.75..827.76 rows=1 width=8) (actual time=13.610..13.611 rows=1 loops=1)

2. 0.512 13.394 ↓ 7.6 1,221 1

Nested Loop Semi Join (cost=0.84..827.34 rows=161 width=0) (actual time=0.505..13.394 rows=1,221 loops=1)

3. 0.422 0.422 ↑ 1.0 1,246 1

Index Only Scan using contacts_tags_pkey on contacts_tags (cost=0.29..43.71 rows=1,255 width=13) (actual time=0.051..0.422 rows=1,246 loops=1)

  • Index Cond: (company_id = '\x4d670aba143e3287b9d4427a'::bytea)
  • Heap Fetches: 0
4. 12.460 12.460 ↑ 1,455.0 1 1,246

Index Only Scan using ix_contacts_tags_associations_company_id_tag_id_contact_id on contacts_tags_associations (cost=0.56..83.55 rows=1,455 width=13) (actual time=0.010..0.010 rows=1 loops=1,246)

  • Index Cond: ((company_id = '\x4d670aba143e3287b9d4427a'::bytea) AND (tag_id = contacts_tags.id))
  • Heap Fetches: 1,221
Planning time : 0.921 ms
Execution time : 13.753 ms