explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2kLM

Settings
# exclusive inclusive rows x rows loops node
1. 706.153 1,887.796 ↑ 1.3 6 1

HashAggregate (cost=365,749.85..365,749.97 rows=8 width=76) (actual time=1,887.793..1,887.796 rows=6 loops=1)

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

Bitmap Heap Scan on "Payment" (cost=8,832.84..361,347.30 rows=293,503 width=13) (actual time=108.117..1,181.643 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: 49347
  • Heap Blocks: exact=26057 lossy=26692
3. 97.323 97.323 ↓ 1.0 301,384 1

Bitmap Index Scan on payment_archivedat_createdat_currency_index (cost=0.00..8,759.46 rows=293,503 width=0) (actual time=97.323..97.323 rows=301,384 loops=1)

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