explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6gP7

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 99.046 ↓ 0.0 0 1

Update on tb_speech_ffom_data d (cost=7.92..15.01 rows=1 width=661) (actual time=99.046..99.046 rows=0 loops=1)

2. 0.003 99.043 ↓ 0.0 0 1

Nested Loop (cost=7.92..15.01 rows=1 width=661) (actual time=99.043..99.043 rows=0 loops=1)

  • Join Filter: (d.seq_id = ANY (a.seq_id_list))
3. 99.040 99.040 ↓ 0.0 0 1

Index Scan using index_speech_ffom_data_data_time on tb_speech_ffom_data d (cost=0.43..7.46 rows=1 width=544) (actual time=99.040..99.040 rows=0 loops=1)

  • Index Cond: (((data_time)::text >= '2019011110'::text) AND ((data_time)::text <= '2019011111'::text))
  • Filter: (status = 1)
  • Rows Removed by Filter: 81246
4. 0.000 0.000 ↓ 0.0 0

Subquery Scan on a (cost=7.48..7.53 rows=1 width=149) (never executed)

5. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=7.48..7.52 rows=1 width=86) (never executed)

  • 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)
6. 0.000 0.000 ↓ 0.0 0

Sort (cost=7.48..7.49 rows=1 width=86) (never executed)

  • 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
7. 0.000 0.000 ↓ 0.0 0

Index Scan using index_speech_ffom_data_data_time on tb_speech_ffom_data (cost=0.43..7.47 rows=1 width=86) (never executed)

  • 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[])))