explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Usdg

Settings
# exclusive inclusive rows x rows loops node
1. 697.685 700.974 ↑ 1.0 1 1

Bitmap Heap Scan on ct00a_nota_fiscal_201702 x (cost=40.03..14,228.15 rows=1 width=323) (actual time=383.394..700.974 rows=1 loops=1)

  • Heap Blocks: lossy=116600
2. 3.289 3.289 ↓ 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=3.289..3.289 rows=1,166,080 loops=1)

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