explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BHxU

Settings
# exclusive inclusive rows x rows loops node
1. 1.475 1.475 ↑ 1.0 1,462 1

Seq Scan on shifts (cost=0.00..1,419.95 rows=1,462 width=446) (actual time=0.007..1.475 rows=1,462 loops=1)

  • Filter: ((deleted_at IS NULL) AND (rate_base = '10'::numeric) AND (rate_overtime = '15'::numeric))
  • Rows Removed by Filter: 668
Planning time : 0.281 ms
Execution time : 1.586 ms