explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hl8

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 7,187.274 ↑ 110.0 1 1

Finalize GroupAggregate (cost=1,291.76..81,072.64 rows=110 width=18) (actual time=7,187.274..7,187.274 rows=1 loops=1)

  • Group Key: t1.enterprise_id
2. 0.789 7,187.417 ↑ 440.0 1 1

Gather (cost=1,291.76..81,069.34 rows=440 width=18) (actual time=7,187.267..7,187.417 rows=1 loops=1)

  • Workers Planned: 4
  • Workers Launched: 0
3. 166.072 7,186.628 ↑ 110.0 1 1

Partial GroupAggregate (cost=291.76..80,025.34 rows=110 width=18) (actual time=7,186.628..7,186.628 rows=1 loops=1)

  • Group Key: t1.enterprise_id
4. 477.433 7,020.556 ↓ 9.3 491,932 1

Hash Join (cost=291.76..79,759.05 rows=53,038 width=298) (actual time=6.166..7,020.556 rows=491,932 loops=1)

  • Hash Cond: (t1.user_id = t2.user_id)
5. 6,537.001 6,537.001 ↓ 4.1 495,835 1

Parallel Seq Scan on ktalk_call_record t1 (cost=0.00..78,022.58 rows=121,910 width=307) (actual time=0.026..6,537.001 rows=495,835 loops=1)

  • Filter: ((enterprise_id = 'yfe491062'::text) AND (is_delete = 0) AND (status = 1))
  • Rows Removed by Filter: 558,290
6. 1.035 6.122 ↓ 1.0 2,880 1

Hash (cost=256.26..256.26 rows=2,840 width=19) (actual time=6.122..6.122 rows=2,880 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 176kB
7. 5.087 5.087 ↓ 1.0 2,880 1

Index Scan using idx_user_enterprise_user_id on user_enterprise_user t2 (cost=0.28..256.26 rows=2,840 width=19) (actual time=0.032..5.087 rows=2,880 loops=1)

  • Index Cond: (enterprise_id = 'yfe491062'::text)
  • Filter: (is_delete = 0)
  • Rows Removed by Filter: 487
Planning time : 3.269 ms
Execution time : 7,187.522 ms