explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Wtg6

Settings
# exclusive inclusive rows x rows loops node
1. 7,643.048 7,643.048 ↑ 1.0 6,615,420 1

Seq Scan on transactions (cost=0.00..1,341,623.73 rows=6,810,707 width=757) (actual time=189.939..7,643.048 rows=6,615,420 loops=1)

  • Filter: (active AND action AND (date_stop >= CURRENT_DATE))
  • Rows Removed by Filter: 2,811,881
  • Functions: 4
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 3.766 ms, Inlining 16.637 ms, Optimization 117.245 ms, Emission 55.790 ms, Total 193.437 ms
Execution time : 7,851.796 ms