explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YRJA

Settings
# exclusive inclusive rows x rows loops node
1. 66.774 66.774 ↓ 1.9 1,135 1

Index Scan using index_web_stats_log_06 on web_stats_log (cost=0.43..12,615.03 rows=609 width=358) (actual time=0.069..66.774 rows=1,135 loops=1)

  • Index Cond: (log_time > '2020-09-01 00:00:00'::timestamp without time zone)
  • Filter: (game_id = 2)
  • Rows Removed by Filter: 137,001
Total runtime : 66.872 ms