explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QVoH

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on CTRPNT_LOG_TXN CTRPNT_LOG_TXN (cost=1,193,309.20..12,294,971.70 rows=24,286,500 width=84) (never executed)

2. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "CTRPNT_LOG_TXN_PK" (cost=0.00..1,187,237.57 rows=24,286,500 width=0) (never executed)

  • Index Cond: (("COLEC_DT" < '2019-07-02 00:00:00'::timestamp without time zone) AND ("COLEC_DT" > '2019-07-01 00:00:00'::timestamp without time zone))