explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fcRr

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 13,295.052 ↓ 0.0 0 1

Update on tb_speech_ffom_data d (cost=7.92..15.02 rows=1 width=661) (actual time=13,295.052..13,295.052 rows=0 loops=1)

2. 2.039 13,295.050 ↓ 0.0 0 1

Nested Loop (cost=7.92..15.02 rows=1 width=661) (actual time=13,295.050..13,295.050 rows=0 loops=1)

  • Join Filter: (d.seq_id = ANY (a.seq_id_list))
3. 148.049 148.049 ↓ 3,394.0 3,394 1

Index Scan using index_speech_ffom_data_data_time on tb_speech_ffom_data d (cost=0.43..7.47 rows=1 width=544) (actual time=0.175..148.049 rows=3,394 loops=1)

  • Index Cond: (((data_time)::text >= '2019011110'::text) AND ((data_time)::text <= '2019011111'::text))
  • Filter: ((status = ANY ('{1,6}'::integer[])) AND (viplevel <= 2) AND (activeness <= 60) AND (level <= 69) AND (channel_type = 9) AND (nlp_content_type = 0))
  • Rows Removed by Filter: 112686
4. 3.394 13,144.962 ↓ 0.0 0 3,394

Subquery Scan on a (cost=7.48..7.53 rows=1 width=149) (actual time=3.873..3.873 rows=0 loops=3,394)

5. 12,072.458 13,141.568 ↓ 0.0 0 3,394

GroupAggregate (cost=7.48..7.52 rows=1 width=86) (actual time=3.872..3.872 rows=0 loops=3,394)

  • 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
6. 943.042 1,069.110 ↓ 3,394.0 3,394 3,394

Sort (cost=7.48..7.49 rows=1 width=86) (actual time=0.039..0.315 rows=3,394 loops=3,394)

  • 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
7. 126.068 126.068 ↓ 3,394.0 3,394 1

Index Scan using index_speech_ffom_data_data_time on tb_speech_ffom_data (cost=0.43..7.47 rows=1 width=86) (actual time=0.150..126.068 rows=3,394 loops=1)

  • Index 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