explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Drnk

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 388.625 ↓ 0.0 0 1

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

2. 0.010 388.622 ↓ 0.0 0 1

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

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

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

4. 2.222 138.409 ↓ 0.0 0 1

GroupAggregate (cost=7.48..8.02 rows=100 width=86) (actual time=138.409..138.409 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. 3.270 136.187 ↓ 1,925.0 1,925 1

Sort (cost=7.48..7.49 rows=1 width=86) (actual time=136.023..136.187 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. 132.917 132.917 ↓ 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=0.247..132.917 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: 92798
7. 81.727 250.200 ↓ 86,442.0 86,442 1

Hash (cost=7.46..7.46 rows=1 width=544) (actual time=250.200..250.200 rows=86,442 loops=1)

  • Buckets: 131072 (originally 1024) Batches: 1 (originally 1) Memory Usage: 25173kB
8. 168.473 168.473 ↓ 86,442.0 86,442 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.162..168.473 rows=86,442 loops=1)

  • Index Cond: (((data_time)::text >= '2019011118'::text) AND ((data_time)::text <= '2019011119'::text))
  • Filter: (status = ANY ('{1,6}'::integer[]))
  • Rows Removed by Filter: 8281