explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7mEu

Settings
# exclusive inclusive rows x rows loops node
1. 687.486 1,192.180 ↑ 1.3 6 1

HashAggregate (cost=364,449.85..364,449.97 rows=8 width=76) (actual time=1,192.175..1,192.180 rows=6 loops=1)

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

Bitmap Heap Scan on "Payment" (cost=7,532.84..360,047.30 rows=293,503 width=13) (actual time=99.726..504.694 rows=301,384 loops=1)

  • Recheck Cond: (("archivedAt" IS NULL) AND ("createdAt" >= '2019-12-13 13:07:46.257+02'::timestamp with time zone))
  • Rows Removed by Index Recheck: 49,347
  • Heap Blocks: exact=26,057 lossy=26,692
3. 90.080 90.080 ↓ 1.0 301,384 1

Bitmap Index Scan on payment_archivedat_createdat_index (cost=0.00..7,459.46 rows=293,503 width=0) (actual time=90.080..90.080 rows=301,384 loops=1)

  • Index Cond: (("archivedAt" IS NULL) AND ("createdAt" >= '2019-12-13 13:07:46.257+02'::timestamp with time zone))