explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HRLe

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 14.908 ↑ 56,904.5 2 1

Bitmap Heap Scan on tb_dado_transp_recebido_online dadotransp0_ (cost=1,511.28..123,498.91 rows=113,809 width=2,716) (actual time=14.902..14.908 rows=2 loops=1)

  • Recheck Cond: ((co_seq_dado_transp_receb_onlin >= 27,232,570::bigint) AND (co_seq_dado_transp_receb_onlin <= 27,232,574::bigint))
2. 14.887 14.887 ↑ 56,904.5 2 1

Bitmap Index Scan on pk_dadotransprecebidoonline (cost=0.00..1,482.83 rows=113,809 width=0) (actual time=14.887..14.887 rows=2 loops=1)

  • Index Cond: ((co_seq_dado_transp_receb_onlin >= 27,232,570::bigint) AND (co_seq_dado_transp_receb_onlin <= 27,232,574::bigint))"Total runtime: 14.986 ms