explain.depesz.com

PostgreSQL's explain analyze made readable

Result: un1I

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 149.759 ↓ 0.0 0 1

Update on tb_speech_hx_data d (cost=77,851.30..78,000.32 rows=1 width=667) (actual time=149.759..149.759 rows=0 loops=1)

2. 0.001 149.757 ↓ 0.0 0 1

Nested Loop (cost=77,851.30..78,000.32 rows=1 width=667) (actual time=149.757..149.757 rows=0 loops=1)

3. 0.001 149.756 ↓ 0.0 0 1

Subquery Scan on a (cost=77,850.87..77,851.32 rows=2 width=150) (actual time=149.756..149.756 rows=0 loops=1)

4. 0.425 149.755 ↓ 0.0 0 1

GroupAggregate (cost=77,850.87..77,851.30 rows=2 width=87) (actual time=149.755..149.755 rows=0 loops=1)

  • Group Key: tb_speech_hx_data.areaid, tb_speech_hx_data.platid, tb_speech_hx_data.zoneid, tb_speech_hx_data.openid, tb_speech_hx_data.roleid
  • Filter: (count(DISTINCT tb_speech_hx_data.targetid) >= 15)
  • Rows Removed by Filter: 48
5. 0.493 149.330 ↓ 14.8 297 1

Sort (cost=77,850.87..77,850.92 rows=20 width=87) (actual time=149.308..149.330 rows=297 loops=1)

  • Sort Key: tb_speech_hx_data.areaid, tb_speech_hx_data.platid, tb_speech_hx_data.zoneid, tb_speech_hx_data.openid, tb_speech_hx_data.roleid
  • Sort Method: quicksort Memory: 66kB
6. 54.399 148.837 ↓ 14.8 297 1

Bitmap Heap Scan on tb_speech_hx_data (cost=739.83..77,850.43 rows=20 width=87) (actual time=97.386..148.837 rows=297 loops=1)

  • Recheck Cond: ((data_time >= '2019011110'::text) AND (data_time <= '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: 38878
  • Heap Blocks: exact=11174
7. 94.438 94.438 ↓ 1.9 58,259 1

Bitmap Index Scan on index_speech_hx_data_data_time (cost=0.00..739.82 rows=30,889 width=0) (actual time=94.438..94.438 rows=58,259 loops=1)

  • Index Cond: ((data_time >= '2019011110'::text) AND (data_time <= '2019011111'::text))
8. 0.000 0.000 ↓ 0.0 0

Index Scan using index_speech_hx_data_seq_id on tb_speech_hx_data d (cost=0.43..74.49 rows=1 width=549) (never executed)

  • Index Cond: (seq_id = ANY (a.seq_id_list))
  • Filter: ((data_time >= '2019011110'::text) AND (data_time <= '2019011111'::text) AND (status = ANY ('{1,6}'::integer[])) AND (viplevel <= 2) AND (activeness <= 60) AND (level <= 69) AND (channel_type = 9) AND (nlp_content_type = 0))