explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kixo

Settings
# exclusive inclusive rows x rows loops node
1. 7.052 362.907 ↑ 110.0 1 1

GroupAggregate (cost=0.71..5,057.29 rows=110 width=18) (actual time=362.906..362.907 rows=1 loops=1)

  • Group Key: t1.enterprise_id
2. 7.661 355.855 ↓ 20.4 28,882 1

Nested Loop (cost=0.71..5,049.12 rows=1,413 width=298) (actual time=2.106..355.855 rows=28,882 loops=1)

3. 0.794 0.794 ↑ 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.046..0.794 rows=300 loops=1)

  • Index Cond: (enterprise_id = 'yfe491040'::text)
  • Filter: (is_delete = 0)
  • Rows Removed by Filter: 90
4. 347.400 347.400 ↓ 7.4 96 300

Index Scan using index_ktalk_call_record__enterprise_id__user_id on ktalk_call_record t1 (cost=0.42..14.70 rows=13 width=307) (actual time=0.050..1.158 rows=96 loops=300)

  • Index Cond: ((enterprise_id = 'yfe491040'::text) AND (user_id = t2.user_id))
  • Filter: ((is_delete = 0) AND (status = 1))
  • Rows Removed by Filter: 2
Planning time : 0.583 ms
Execution time : 362.995 ms