explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y5jv

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

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

2. 0.008 759.465 ↑ 1.0 1 1

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

3. 755.616 759.428 ↑ 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=394.959..759.428 rows=1 loops=1)

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

  • Index Cond: ((ct00a_id = 282502269) AND (ct00a_revisao = 319110040))
5. 0.029 0.029 ↑ 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.029..0.029 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.268 ms
Execution time : 759.545 ms