explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tdif

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 5.733 ↓ 0.0 0 1

GroupAggregate (cost=656.11..660.07 rows=5 width=88) (actual time=5.733..5.733 rows=0 loops=1)

  • Group Key: (("Tag_2019_12_01"."trendTime" - ("Tag_2019_12_01"."trendTime" % '120000'::bigint))), "Tag_2019_12_01".header
  • Buffers: shared hit=495 read=12
2. 0.048 5.732 ↓ 0.0 0 1

Sort (cost=656.11..656.12 rows=5 width=44) (actual time=5.731..5.732 rows=0 loops=1)

  • Sort Key: (("Tag_2019_12_01"."trendTime" - ("Tag_2019_12_01"."trendTime" % '120000'::bigint))), "Tag_2019_12_01".header
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=495 read=12
3. 0.003 5.684 ↓ 0.0 0 1

Append (cost=0.42..656.05 rows=5 width=44) (actual time=5.684..5.684 rows=0 loops=1)

  • Buffers: shared hit=492 read=12
4. 1.393 1.393 ↓ 0.0 0 1

Index Scan using "Tag_2019_12_01_header_trendTime_idx" on "Tag_2019_12_01" (cost=0.42..163.76 rows=1 width=44) (actual time=1.393..1.393 rows=0 loops=1)

  • Index Cond: ((header = ANY ('{504388,507785,505844,408480,405793,668409,637241,343827,405652,307854,669693,374951,406682,538602,507404,408474,473438,440645,506540,406153,638768,573061,505805,374603,374332,636411,603163,407632,404676,373336,540258,374938,409103,342324,440122,637125}'::bigint[])) AND ("trendTime" >= '1581372600000'::bigint) AND ("trendTime" < '1581372720000'::bigint))
  • Buffers: shared hit=105 read=3
5. 1.905 1.905 ↓ 0.0 0 1

Index Scan using "Tag_2019_12_18_header_trendTime_idx" on "Tag_2019_12_18" (cost=0.42..159.49 rows=1 width=44) (actual time=1.905..1.905 rows=0 loops=1)

  • Index Cond: ((header = ANY ('{504388,507785,505844,408480,405793,668409,637241,343827,405652,307854,669693,374951,406682,538602,507404,408474,473438,440645,506540,406153,638768,573061,505805,374603,374332,636411,603163,407632,404676,373336,540258,374938,409103,342324,440122,637125}'::bigint[])) AND ("trendTime" >= '1581372600000'::bigint) AND ("trendTime" < '1581372720000'::bigint))
  • Buffers: shared hit=105 read=3
6. 1.216 1.216 ↓ 0.0 0 1

Index Scan using "Tag_2019_12_25_header_trendTime_idx" on "Tag_2019_12_25" (cost=0.42..159.49 rows=1 width=44) (actual time=1.216..1.216 rows=0 loops=1)

  • Index Cond: ((header = ANY ('{504388,507785,505844,408480,405793,668409,637241,343827,405652,307854,669693,374951,406682,538602,507404,408474,473438,440645,506540,406153,638768,573061,505805,374603,374332,636411,603163,407632,404676,373336,540258,374938,409103,342324,440122,637125}'::bigint[])) AND ("trendTime" >= '1581372600000'::bigint) AND ("trendTime" < '1581372720000'::bigint))
  • Buffers: shared hit=105 read=3
7. 1.136 1.136 ↓ 0.0 0 1

Index Scan using "Tag_2019_12_26_header_trendTime_idx" on "Tag_2019_12_26" (cost=0.42..159.49 rows=1 width=44) (actual time=1.136..1.136 rows=0 loops=1)

  • Index Cond: ((header = ANY ('{504388,507785,505844,408480,405793,668409,637241,343827,405652,307854,669693,374951,406682,538602,507404,408474,473438,440645,506540,406153,638768,573061,505805,374603,374332,636411,603163,407632,404676,373336,540258,374938,409103,342324,440122,637125}'::bigint[])) AND ("trendTime" >= '1581372600000'::bigint) AND ("trendTime" < '1581372720000'::bigint))
  • Buffers: shared hit=105 read=3
8. 0.031 0.031 ↓ 0.0 0 1

Index Scan using "Tag_2019_12_27_header_trendTime_idx" on "Tag_2019_12_27" (cost=0.15..13.78 rows=1 width=44) (actual time=0.031..0.031 rows=0 loops=1)

  • Index Cond: ((header = ANY ('{504388,507785,505844,408480,405793,668409,637241,343827,405652,307854,669693,374951,406682,538602,507404,408474,473438,440645,506540,406153,638768,573061,505805,374603,374332,636411,603163,407632,404676,373336,540258,374938,409103,342324,440122,637125}'::bigint[])) AND ("trendTime" >= '1581372600000'::bigint) AND ("trendTime" < '1581372720000'::bigint))
  • Buffers: shared hit=72
Planning time : 0.667 ms