explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DtkP

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

Limit (cost=2,742.13..2,742.14 rows=1 width=104) (actual time=0.132..0.132 rows=0 loops=1)

  • Buffers: shared hit=27
2.          

CTE cte

3. 0.001 0.119 ↑ 259.3 7 1

Limit (cost=2,687.67..2,692.21 rows=1,815 width=104) (actual time=0.117..0.119 rows=7 loops=1)

  • Buffers: shared hit=27
4. 0.009 0.118 ↑ 259.3 7 1

Sort (cost=2,687.67..2,692.21 rows=1,815 width=104) (actual time=0.117..0.118 rows=7 loops=1)

  • Sort Key: p_1.date DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=27
5. 0.002 0.109 ↑ 259.3 7 1

Append (cost=0.43..2,589.43 rows=1,815 width=104) (actual time=0.051..0.109 rows=7 loops=1)

  • Buffers: shared hit=27
6. 0.031 0.031 ↓ 0.0 0 1

Index Scan using points_18264_blocknumber_idx on points_18264 p_1 (cost=0.43..553.66 rows=1 width=87) (actual time=0.031..0.031 rows=0 loops=1)

  • Index Cond: (blocknumber = '353607080114106'::text)
  • Filter: (received >= '2020-01-05 20:59:59'::timestamp without time zone)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=7
7. 0.028 0.028 ↑ 173.7 3 1

Index Scan using points_18265_blocknumber_idx on points_18265 p_2 (cost=0.43..584.83 rows=521 width=87) (actual time=0.020..0.028 rows=3 loops=1)

  • Index Cond: (blocknumber = '353607080114106'::text)
  • Buffers: shared hit=6
8. 0.018 0.018 ↑ 244.5 2 1

Index Scan using points_18266_blocknumber_idx on points_18266 p_3 (cost=0.43..548.43 rows=489 width=87) (actual time=0.015..0.018 rows=2 loops=1)

  • Index Cond: (blocknumber = '353607080114106'::text)
  • Buffers: shared hit=6
9. 0.017 0.017 ↑ 249.0 2 1

Index Scan using points_18267_blocknumber_idx on points_18267 p_4 (cost=0.43..558.94 rows=498 width=87) (actual time=0.015..0.017 rows=2 loops=1)

  • Index Cond: (blocknumber = '353607080114106'::text)
  • Buffers: shared hit=5
10. 0.013 0.013 ↓ 0.0 0 1

Index Scan using points_18268_blocknumber_idx on points_18268 p_5 (cost=0.43..343.57 rows=306 width=87) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (blocknumber = '353607080114106'::text)
  • Buffers: shared hit=3
11. 0.008 0.131 ↓ 0.0 0 1

Sort (cost=49.92..49.93 rows=1 width=104) (actual time=0.131..0.131 rows=0 loops=1)

  • Sort Key: p.date DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=27
12. 0.123 0.123 ↓ 0.0 0 1

CTE Scan on cte p (cost=0.00..49.91 rows=1 width=104) (actual time=0.123..0.123 rows=0 loops=1)

  • Filter: ((date >= '2020-01-08 20:59:58.999'::timestamp without time zone) AND (date <= '2020-01-09 21:00:00.001'::timestamp without time zone) AND (blocknumber = '353607080114106'::text))
  • Rows Removed by Filter: 7
  • Buffers: shared hit=27
Planning time : 0.451 ms
Execution time : 0.187 ms