explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C6GI

Settings
# exclusive inclusive rows x rows loops node
1. 686.426 2,991.715 ↑ 1.3 6 1

HashAggregate (cost=390,529.17..390,529.29 rows=8 width=76) (actual time=2,991.711..2,991.715 rows=6 loops=1)

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

Seq Scan on "Payment" (cost=0.00..386,126.62 rows=293,503 width=13) (actual time=6.193..2,305.289 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 : 2.472 ms