explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CXKF

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.132 ↑ 1.0 10 1

Limit (cost=0.10..2.77 rows=10 width=200) (actual time=0.093..0.132 rows=10 loops=1)

2. 0.023 0.130 ↑ 793.5 10 1

GroupAggregate (cost=0.10..2,121.96 rows=7,935 width=200) (actual time=0.092..0.130 rows=10 loops=1)

  • Group Key: tb_points.id_point
3. 0.004 0.107 ↑ 932.3 11 1

Nested Loop (cost=0.10..2,088.15 rows=10,255 width=38) (actual time=0.068..0.107 rows=11 loops=1)

4. 0.037 0.037 ↑ 932.3 11 1

Index Scan Backward using tb_bar_five_minute_im_pk on tb_bar_five_minute tb_points (cost=0.06..2,074.88 rows=10,255 width=42) (actual time=0.015..0.037 rows=11 loops=1)

  • Index Cond: ((id_stock = 9363) AND (id_point < '201911260000'::bigint))
5. 0.003 0.066 ↑ 1.0 1 11

Materialize (cost=0.04..0.44 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=11)

6. 0.063 0.063 ↑ 1.0 1 1

Index Scan using tb_stock_im_pk on tb_stock (cost=0.04..0.44 rows=1 width=8) (actual time=0.051..0.063 rows=1 loops=1)

  • Index Cond: (id_stock = 9363)
  • Filter: (id_exchange = 1)
Planning time : 0.639 ms
Execution time : 0.171 ms