explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C73

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 511.205 ↓ 1.1 30 1

Limit (cost=0.84..102.98 rows=28 width=17) (actual time=24.171..511.205 rows=30 loops=1)

2. 0.144 511.189 ↓ 1.1 30 1

Nested Loop (cost=0.84..102.98 rows=28 width=17) (actual time=24.170..511.189 rows=30 loops=1)

3. 4.975 4.975 ↑ 1.1 30 1

Index Only Scan using contacts_importance_company_id_user_id_is_important_contact_id on contacts_importance (cost=0.42..18.26 rows=32 width=26) (actual time=4.807..4.975 rows=30 loops=1)

  • Index Cond: ((company_id = '\x4c2118ad54397f271b000000'::bytea) AND (user_id = '\x4c21187154397f270a000001'::bytea) AND (is_important = true))
  • Filter: (is_important IS TRUE)
  • Heap Fetches: 30
4. 506.070 506.070 ↑ 1.0 1 30

Index Only Scan using contacts_pkey on contacts (cost=0.43..2.65 rows=1 width=26) (actual time=16.869..16.869 rows=1 loops=30)

  • Index Cond: ((company_id = '\x4c2118ad54397f271b000000'::bytea) AND (id = contacts_importance.contact_id))
  • Heap Fetches: 30
Planning time : 33.542 ms
Execution time : 511.278 ms