explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lvjT

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 717.737 ↑ 1.0 1 1

Nested Loop (cost=40.87..14,264.64 rows=1 width=219) (actual time=380.4..717.737 rows=1 loops=1)

2. 0.007 717.715 ↑ 1.0 1 1

Nested Loop (cost=40.6..14,256.34 rows=1 width=183) (actual time=380.379..717.715 rows=1 loops=1)

3. 0.021 0.021 ↑ 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.017..0.021 rows=1 loops=1)

  • Index Cond: (ct00_id = 282,502,269)
  • Heap Fetches: 1
4. 714.423 717.687 ↑ 1.0 1 1

Bitmap Heap Scan on ct00a_nota_fiscal_201702 ct00a_nota_fiscal_201702 (cost=40.03..14,247.74 rows=1 width=183) (actual time=380.356..717.687 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=116,600
5. 3.264 3.264 ↓ 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.264..3.264 rows=1,166,080 loops=1)

  • Index Cond: ((ct00a_id = 282,502,269) AND (ct00a_revisao = 319,110,040))
6. 0.015 0.015 ↓ 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.015..0.015 rows=0 loops=1)

  • Index Cond: (ct00c_id_nota_fiscal = 282,502,269)
Planning time : 0.447 ms
Execution time : 717.789 ms