explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yTmo

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 3,582.139 ↓ 0.0 0 1

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

2. 0.610 3,582.137 ↓ 0.0 0 1

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

  • Join Filter: ((d.areaid = a.areaid) AND (d.platid = a.platid) AND (d.zoneid = a.zoneid) AND (d.openid = a.openid) AND (d.roleid = a.roleid) AND (d.seq_id = ANY (a.seq_id_list)))
3. 94.853 94.853 ↓ 1,163.0 1,163 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=0.156..94.853 rows=1,163 loops=1)

  • Index Cond: (((data_time)::text >= '2019011110'::text) AND ((data_time)::text <= '2019011111'::text))
  • Filter: (status = 1)
  • Rows Removed by Filter: 85635
4. 1.163 3,486.674 ↓ 0.0 0 1,163

Subquery Scan on a (cost=7.48..7.53 rows=1 width=210) (actual time=2.998..2.998 rows=0 loops=1,163)

5. 3,156.382 3,485.511 ↓ 0.0 0 1,163

GroupAggregate (cost=7.48..7.52 rows=1 width=86) (actual time=2.997..2.997 rows=0 loops=1,163)

  • 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: 362
6. 241.773 329.129 ↓ 2,575.0 2,575 1,163

Sort (cost=7.48..7.49 rows=1 width=86) (actual time=0.079..0.283 rows=2,575 loops=1,163)

  • 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: 459kB
7. 87.356 87.356 ↓ 2,575.0 2,575 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.137..87.356 rows=2,575 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: 84223