explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HnLu

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 653.211 ↑ 1.0 1 1

Nested Loop (cost=40.87..14,245.05 rows=1 width=219) (actual time=343.38..653.211 rows=1 loops=1)

2. 0.009 653.199 ↑ 1.0 1 1

Nested Loop (cost=40.6..14,236.75 rows=1 width=183) (actual time=343.369..653.199 rows=1 loops=1)

3. 649.245 653.163 ↑ 1.0 1 1

Bitmap Heap Scan on ct00a_nota_fiscal_201702 ct00a_nota_fiscal_201702 (cost=40.03..14,228.15 rows=1 width=183) (actual time=343.335..653.163 rows=1 loops=1)

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

  • Index Cond: ((ct00a_id = 282502269) AND (ct00a_revisao = 319110040))
5. 0.027 0.027 ↑ 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.027..0.027 rows=1 loops=1)

  • Index Cond: (ct00_id = 282502269)
  • Heap Fetches: 1
6. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (ct00c_id_nota_fiscal = 282502269)
Planning time : 0.28 ms
Execution time : 653.274 ms