explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7f8l

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

Update on tb_speech_ffom_data d (cost=14.95..16.87 rows=1 width=576) (actual time=250.569..250.569 rows=0 loops=1)

2. 0.008 250.567 ↓ 0.0 0 1

Hash Join (cost=14.95..16.87 rows=1 width=576) (actual time=250.567..250.567 rows=0 loops=1)

  • Hash Cond: (a.seq_id = d.seq_id)
3. 0.002 121.683 ↓ 0.0 0 1

Subquery Scan on a (cost=7.48..9.02 rows=100 width=40) (actual time=121.683..121.683 rows=0 loops=1)

4. 2.073 121.681 ↓ 0.0 0 1

GroupAggregate (cost=7.48..8.02 rows=100 width=86) (actual time=121.681..121.681 rows=0 loops=1)

  • 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: 272
5. 4.559 119.608 ↓ 1,925.0 1,925 1

Sort (cost=7.48..7.49 rows=1 width=86) (actual time=119.447..119.608 rows=1,925 loops=1)

  • 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: 319kB
6. 115.049 115.049 ↓ 1,925.0 1,925 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=4.662..115.049 rows=1,925 loops=1)

  • Index Cond: (((data_time)::text >= '2019011118'::text) AND ((data_time)::text <= '2019011119'::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: 90379
7. 6.144 128.876 ↓ 7,151.0 7,151 1

Hash (cost=7.46..7.46 rows=1 width=544) (actual time=128.876..128.876 rows=7,151 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 2062kB
8. 122.732 122.732 ↓ 7,151.0 7,151 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=5.786..122.732 rows=7,151 loops=1)

  • Index Cond: (((data_time)::text >= '2019011118'::text) AND ((data_time)::text <= '2019011119'::text))
  • Filter: (status = 1)
  • Rows Removed by Filter: 85153