explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GgOA

Settings
# exclusive inclusive rows x rows loops node
1. 5.453 346.228 ↑ 110.0 1 1

GroupAggregate (cost=0.71..5,036.06 rows=110 width=18) (actual time=346.228..346.228 rows=1 loops=1)

  • Group Key: t1.enterprise_id
2. 6.726 340.775 ↓ 20.3 29,337 1

Nested Loop (cost=0.71..5,027.74 rows=1,445 width=298) (actual time=1.698..340.775 rows=29,337 loops=1)

3. 0.749 0.749 ↑ 1.1 300 1

Index Scan using idx_user_enterprise_user_id on user_enterprise_user t2 (cost=0.28..169.16 rows=329 width=19) (actual time=0.048..0.749 rows=300 loops=1)

  • Index Cond: (enterprise_id = 'yfe491040'::text)
  • Filter: (is_delete = 0)
  • Rows Removed by Filter: 90
4. 333.300 333.300 ↓ 7.5 98 300

Index Scan using index_ktalk_call_record__enterprise_id__user_id on ktalk_call_record t1 (cost=0.42..14.64 rows=13 width=307) (actual time=0.034..1.111 rows=98 loops=300)

  • Index Cond: ((enterprise_id = 'yfe491040'::text) AND (user_id = t2.user_id))
Planning time : 0.398 ms
Execution time : 346.292 ms