explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2nHO

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 689.914 ↑ 1.0 1 1

Nested Loop (cost=40.87..14,202.17 rows=1 width=219) (actual time=369.086..689.914 rows=1 loops=1)

2. 0.007 689.889 ↑ 1.0 1 1

Nested Loop (cost=40.6..14,193.87 rows=1 width=183) (actual time=369.067..689.889 rows=1 loops=1)

3. 0.023 0.023 ↑ 1.0 1 1

Index Only Scan using ct00_nota_fiscal_pkey on ct00_notafiscalrevisao ct00_notafiscalrevisao (cost=0.57..8.59 rows=1 width=8) (actual time=0.021..0.023 rows=1 loops=1)

  • Index Cond: (ct00_id = 282502269)
  • Heap Fetches: 1
4. 686.071 689.859 ↑ 1.0 1 1

Bitmap Heap Scan on ct00a_nota_fiscal_201702 ct00a_nota_fiscal_201702 (cost=40.03..14,185.27 rows=1 width=183) (actual time=369.041..689.859 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
5. 3.788 3.788 ↓ 299.0 1,166,080 1

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

  • Index Cond: ((ct00a_id = 282502269) AND (ct00a_revisao = 319110040))
6. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix00_ct00c_id_nota_fiscal on ct00c_capa_nota_importacao ct00c_capa_nota_importacao (cost=0.27..8.29 rows=1 width=36) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (ct00c_id_nota_fiscal = 282502269)
Planning time : 0.216 ms
Execution time : 689.977 ms