explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aB68 : IS

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.527 ↑ 1.0 100 1

Limit (cost=1.27..223.24 rows=100 width=17) (actual time=0.062..0.527 rows=100 loops=1)

2. 0.001 0.519 ↑ 8.7 100 1

Nested Loop (cost=1.27..1,921.31 rows=865 width=17) (actual time=0.062..0.519 rows=100 loops=1)

3. 0.007 0.118 ↑ 10.8 100 1

Nested Loop (cost=0.84..1,433.41 rows=1,083 width=26) (actual time=0.048..0.118 rows=100 loops=1)

4. 0.018 0.018 ↑ 1.0 1 1

Index Only Scan using ix_contacts_tags_company_id_tag_tag_id on contacts_tags (cost=0.28..2.50 rows=1 width=26) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: ((company_id = '\x4c2118ad54397f271b000000'::bytea) AND (tag = 'import1502910941'::text))
  • Heap Fetches: 1
5. 0.093 0.093 ↑ 27.6 100 1

Index Only Scan using ix_contacts_tags_associations_company_id_tag_id_contact_id on contacts_tags_associations (cost=0.56..1,403.34 rows=2,757 width=39) (actual time=0.027..0.093 rows=100 loops=1)

  • Index Cond: ((company_id = '\x4c2118ad54397f271b000000'::bytea) AND (tag_id = contacts_tags.id))
  • Heap Fetches: 100
6. 0.400 0.400 ↑ 1.0 1 100

Index Only Scan using ix_company_id_id on contacts (cost=0.43..0.45 rows=1 width=26) (actual time=0.004..0.004 rows=1 loops=100)

  • Index Cond: ((company_id = '\x4c2118ad54397f271b000000'::bytea) AND (id = contacts_tags_associations.contact_id))
  • Heap Fetches: 1
Planning time : 0.589 ms
Execution time : 0.577 ms