explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aE1q

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 451,420.577 ↓ 0.0 0 1

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

2. 63.077 451,420.576 ↓ 0.0 0 1

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

  • Join Filter: (d.seq_id = ANY (a.seq_id_list))
3. 459.061 459.061 ↓ 115,942.0 115,942 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.271..459.061 rows=115,942 loops=1)

  • Index Cond: (((data_time)::text >= '2019011110'::text) AND ((data_time)::text <= '2019011111'::text))
  • Filter: (status = ANY ('{1,6}'::integer[]))
  • Rows Removed by Filter: 138
4. 115.942 450,898.438 ↓ 0.0 0 115,942

Subquery Scan on a (cost=7.48..7.53 rows=1 width=149) (actual time=3.889..3.889 rows=0 loops=115,942)

5. 417,854.968 450,782.496 ↓ 0.0 0 115,942

GroupAggregate (cost=7.48..7.52 rows=1 width=86) (actual time=3.888..3.888 rows=0 loops=115,942)

  • 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. 32,804.632 32,927.528 ↓ 3,394.0 3,394 115,942

Sort (cost=7.48..7.49 rows=1 width=86) (actual time=0.001..0.284 rows=3,394 loops=115,942)

  • 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. 122.896 122.896 ↓ 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.278..122.896 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