explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SUlB

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 3.769 ↑ 1.0 30 1

Limit (cost=1.27..74.08 rows=30 width=17) (actual time=3.509..3.769 rows=30 loops=1)

2. 0.030 3.764 ↑ 25.6 30 1

Nested Loop (cost=1.27..1,867.70 rows=769 width=17) (actual time=3.508..3.764 rows=30 loops=1)

3. 0.011 2.234 ↑ 32.1 30 1

Nested Loop (cost=0.84..1,433.41 rows=964 width=26) (actual time=2.205..2.234 rows=30 loops=1)

4. 0.045 0.045 ↑ 1.0 1 1

Index Scan using ix_contacts_tags_company_id_tag on contacts_tags (cost=0.28..2.50 rows=1 width=26) (actual time=0.045..0.045 rows=1 loops=1)

  • Index Cond: ((company_id = '\x4c2118ad54397f271b000000'::bytea) AND (tag = '00_bulk_131'::text))
5. 2.178 2.178 ↑ 91.9 30 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=2.153..2.178 rows=30 loops=1)

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

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

  • Index Cond: ((company_id = '\x4c2118ad54397f271b000000'::bytea) AND (id = contacts_tags_associations.contact_id))
  • Heap Fetches: 0
Planning time : 24.147 ms
Execution time : 3.936 ms