explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UFps

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 11,491.690 ↓ 0.0 0 1

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

2. 2.685 11,491.688 ↓ 0.0 0 1

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

  • Join Filter: (d.seq_id = ANY (a.seq_id_list))
3. 149.772 149.772 ↓ 3,049.0 3,049 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.211..149.772 rows=3,049 loops=1)

  • Index Cond: (((data_time)::text >= '2019011117'::text) AND ((data_time)::text <= '2019011118'::text))
  • Filter: (status = 1)
  • Rows Removed by Filter: 123756
4. 0.000 11,339.231 ↓ 0.0 0 3,049

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

5. 10,366.600 11,339.231 ↓ 0.0 0 3,049

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

  • 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: 393
6. 815.484 972.631 ↓ 3,094.0 3,094 3,049

Sort (cost=7.48..7.49 rows=1 width=86) (actual time=0.054..0.319 rows=3,094 loops=3,049)

  • 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: 532kB
7. 157.147 157.147 ↓ 3,094.0 3,094 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.537..157.147 rows=3,094 loops=1)

  • Index Cond: (((data_time)::text >= '2019011117'::text) AND ((data_time)::text <= '2019011118'::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: 123711