explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M44k

Settings
# exclusive inclusive rows x rows loops node
1. 762.843 767.162 ↑ 1.0 1 1

Bitmap Heap Scan on ct00a_nota_fiscal_201702 x (cost=40.03..14,247.74 rows=1 width=323) (actual time=423.203..767.162 rows=1 loops=1)

  • Filter: ((ct00a_dt_competencia >= '2017-02-01 00:00:00'::timestamp without time zone) AND (ct00a_dt_competencia <= '2017-02-28 23:59:59.998'::timestamp without time zone))
  • Heap Blocks: lossy=116600
2. 4.319 4.319 ↓ 297.6 1,166,080 1

Bitmap Index Scan on idx_ct00a_nota_fiscal_201702_id_revisao (cost=0..40.03 rows=3,918 width=0) (actual time=4.319..4.319 rows=1,166,080 loops=1)

  • Index Cond: ((ct00a_id = 282502269) AND (ct00a_revisao = 319110040))
Planning time : 0.194 ms
Execution time : 767.205 ms