explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x9k

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 142.848 ↓ 0.0 0 1

Update on tb_speech_ffom_data d (cost=259,516.30..263,241.26 rows=6 width=661) (actual time=142.848..142.848 rows=0 loops=1)

2. 0.001 142.847 ↓ 0.0 0 1

Nested Loop (cost=259,516.30..263,241.26 rows=6 width=661) (actual time=142.847..142.847 rows=0 loops=1)

3. 0.001 142.846 ↓ 0.0 0 1

Subquery Scan on a (cost=259,515.74..259,526.63 rows=49 width=149) (actual time=142.846..142.846 rows=0 loops=1)

4. 3.570 142.845 ↓ 0.0 0 1

GroupAggregate (cost=259,515.74..259,526.14 rows=49 width=86) (actual time=142.845..142.845 rows=0 loops=1)

  • Group Key: tb_speech_ffom_data.areaid, tb_speech_ffom_data.platid, tb_speech_ffom_data.zoneid, tb_speech_ffom_data.openid, tb_speech_ffom_data.roleid
  • Filter: (count(DISTINCT tb_speech_ffom_data.targetid) >= 15)
  • Rows Removed by Filter: 454
5. 6.177 139.275 ↓ 7.0 3,394 1

Sort (cost=259,515.74..259,516.95 rows=483 width=86) (actual time=139.021..139.275 rows=3,394 loops=1)

  • Sort Key: tb_speech_ffom_data.areaid, tb_speech_ffom_data.platid, tb_speech_ffom_data.zoneid, tb_speech_ffom_data.openid, tb_speech_ffom_data.roleid
  • Sort Method: quicksort Memory: 574kB
6. 61.076 133.098 ↓ 7.0 3,394 1

Bitmap Heap Scan on tb_speech_ffom_data (cost=2,788.24..259,494.21 rows=483 width=86) (actual time=74.223..133.098 rows=3,394 loops=1)

  • Recheck Cond: (((data_time)::text >= '2019011110'::text) AND ((data_time)::text <= '2019011111'::text))
  • Filter: ((viplevel <= 2) AND (activeness <= 60) AND (level <= 69) AND (channel_type = 9) AND (nlp_content_type = 0) AND (status = ANY ('{1,2,4,6,7}'::integer[])))
  • Rows Removed by Filter: 112686
  • Heap Blocks: exact=10509
7. 72.022 72.022 ↓ 1.0 116,106 1

Bitmap Index Scan on index_speech_ffom_data_data_time (cost=0.00..2,788.12 rows=114,968 width=0) (actual time=72.022..72.022 rows=116,106 loops=1)

  • Index Cond: (((data_time)::text >= '2019011110'::text) AND ((data_time)::text <= '2019011111'::text))
8. 0.000 0.000 ↓ 0.0 0

Index Scan using index_speech_ffom_data_seq_id on tb_speech_ffom_data d (cost=0.56..75.80 rows=1 width=544) (never executed)

  • Index Cond: (seq_id = ANY (a.seq_id_list))
  • Filter: (((data_time)::text >= '2019011110'::text) AND ((data_time)::text <= '2019011111'::text) AND (status = ANY ('{1,6}'::integer[])))