explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WAO9

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.025 ↑ 1.0 20 1

Limit (cost=0.28..5.13 rows=20 width=66) (actual time=0.019..0.025 rows=20 loops=1)

2. 0.023 0.023 ↑ 28.5 20 1

Index Scan Backward using lucky_draw_spins_id_is_win_index on lucky_draw_spins (cost=0.28..138.68 rows=570 width=66) (actual time=0.018..0.023 rows=20 loops=1)

  • Index Cond: (is_win = true)
  • Filter: is_win