explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RLWt

Settings
# exclusive inclusive rows x rows loops node
1. 11,572.740 11,572.740 ↑ 4.0 2 1

HashAggregate (cost=181,018.14..181,018.22 rows=8 width=12) (actual time=11,572.738..11,572.740 rows=2 loops=1)

  • -> Seq Scan on organic_sense_keywordrank "position" (cost=0.00..177899.10 rows=623808 width=12) (actual time=327.593..11252.795 rows=587400 loops
  • Filter: ((date >= '2018-12-25'::date) AND (date <= '2018-12-26'::date))
  • Rows Removed by Filter: 4494210