explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SpS6

Settings
# exclusive inclusive rows x rows loops node
1. 669.607 3,044.191 ↑ 1.3 6 1

HashAggregate (cost=390,529.17..390,529.29 rows=8 width=76) (actual time=3,044.182..3,044.191 rows=6 loops=1)

  • Group Key: currency
2. 2,374.584 2,374.584 ↓ 1.0 301,384 1

Seq Scan on "Payment" (cost=0.00..386,126.62 rows=293,503 width=13) (actual time=7.224..2,374.584 rows=301,384 loops=1)

  • Filter: (("archivedAt" IS NULL) AND ("createdAt" >= '2019-12-13 13:07:46.257+02'::timestamp with time zone))
  • Rows Removed by Filter: 2739786
Planning time : 0.269 ms