explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xmg6

Settings
# exclusive inclusive rows x rows loops node
1. 1.044 1.044 ↑ 1.0 456 1

Index Scan using idx_dim_date_pkey on dim_date dim_date (cost=0.42..493.46 rows=460 width=155) (actual time=0.029..1.044 rows=456 loops=1)

  • Index Cond: ((dim_date.date > '2024-10-01'::date) AND (dim_date.client_sk = 17))
  • Buffers: shared hit=375
Planning time : 0.15 ms
Execution time : 1.104 ms