explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FNAK

Settings
# exclusive inclusive rows x rows loops node
1. 2,974.028 2,974.028 ↑ 1.0 4,350,232 1

Seq Scan on positions (cost=0.00..393,294.26 rows=4,350,284 width=532) (actual time=14.267..2,974.028 rows=4,350,232 loops=1)

  • Filter: (date_stop >= CURRENT_DATE)
  • Functions: 4
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 2.204 ms, Inlining 0.000 ms, Optimization 1.455 ms, Emission 12.635 ms, Total 16.294 ms
Execution time : 3,109.162 ms