explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IGj7

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 7,960.107 ↑ 1.0 1 1

Aggregate (cost=60.48..60.49 rows=1 width=8) (actual time=7,960.106..7,960.107 rows=1 loops=1)

  • Output: max(beia_trb.reg_date)
  • Buffers: shared hit=55,077 read=961
2. 3.671 7,960.100 ↓ 0.0 0 1

Nested Loop (cost=1.27..60.48 rows=1 width=8) (actual time=7,960.100..7,960.100 rows=0 loops=1)

  • Output: beia_trb.reg_date
  • Join Filter: (bei_nc.bus_ent_inst_id_auto = beia_trb.bus_ent_inst_id)
  • Buffers: shared hit=55,077 read=961
3. 4.157 7,891.429 ↓ 1,000.0 1,000 1

Nested Loop (cost=0.85..56.25 rows=1 width=8) (actual time=9.966..7,891.429 rows=1,000 loops=1)

  • Output: bei_nc.bus_ent_inst_id_auto, beia_prio.bus_ent_inst_id
  • Buffers: shared hit=52,094 read=942
4. 18.975 391.751 ↓ 5,797.0 5,797 1

Nested Loop (cost=0.42..47.79 rows=1 width=4) (actual time=1.873..391.751 rows=5,797 loops=1)

  • Output: bei_nc.bus_ent_inst_id_auto
  • Join Filter: (bei_nc.ent_sta_id = bes.ent_sta_id_auto)
  • Rows Removed by Join Filter: 63,287
  • Buffers: shared hit=34,599
5. 50.384 50.384 ↓ 11,514.0 11,514 1

Index Scan using ix_bus_ent_instance_fsc_fiscalia on public.bus_ent_instance bei_nc (cost=0.42..44.07 rows=1 width=8) (actual time=1.814..50.384 rows=11,514 loops=1)

  • Output: bei_nc.env_id, bei_nc.bus_ent_inst_id_auto, bei_nc.bus_ent_id, bei_nc.bus_ent_inst_name_pos, bei_nc.bus_ent_inst_name_num, bei_nc.bus_ent_inst_name_pre, bei_nc.bus_ent_inst_create_user, bei_nc.bus_ent_inst_create_data, bei (...)
  • Index Cond: (((bei_nc.att_value_9)::text = '44'::text) AND (bei_nc.att_value_num_2 IS NOT NULL))
  • Filter: ((bei_nc.bus_ent_inst_name_pre)::text = 'NC'::text)
  • Buffers: shared hit=11,571
6. 322.392 322.392 ↑ 1.0 6 11,514

Seq Scan on public.bus_ent_status bes (cost=0.00..3.64 rows=6 width=4) (actual time=0.002..0.028 rows=6 loops=11,514)

  • Output: bes.env_id, bes.ent_sta_id_auto, bes.ent_sta_name, bes.ent_sta_desc, bes.prj_id, bes.reg_user, bes.reg_status, bes.reg_date
  • Filter: ((bes.env_id = 1,001) AND (bes.reg_status = 0) AND ((bes.ent_sta_name)::text = ANY ('{NC_DPM,NC_AUTO_ASIGNADA,NC_FORMALIZADO,NC_FORMALIZACION_EN_TRAMITE,NC_EN_JUICIO,NC_MODIFICADA}'::text[])))
  • Rows Removed by Filter: 67
  • Buffers: shared hit=23,028
7. 7,495.521 7,495.521 ↓ 0.0 0 5,797

Index Scan using ix_bus_ent_inst_attribute_rep_formali_1427 on public.bus_ent_inst_attribute beia_prio (cost=0.42..8.45 rows=1 width=4) (actual time=1.293..1.293 rows=0 loops=5,797)

  • Output: beia_prio.env_id, beia_prio.bus_ent_inst_id, beia_prio.att_id, beia_prio.att_row_id_auto, beia_prio.att_index_id, beia_prio.ent_inst_att_num_value, beia_prio.ent_inst_att_str_value, beia_prio.ent_inst_att_dte_value, beia_prio.en (...)
  • Index Cond: ((beia_prio.bus_ent_inst_id = bei_nc.bus_ent_inst_id_auto) AND (beia_prio.att_id = 1,427) AND (beia_prio.ent_inst_att_num_value = '1'::numeric) AND (beia_prio.env_id = 1,001))
  • Filter: (beia_prio.reg_status = 0)
  • Buffers: shared hit=17,495 read=942
8. 65.000 65.000 ↓ 0.0 0 1,000

Index Only Scan using ix_bus_ent_inst_attribute_nc_trabajada on public.bus_ent_inst_attribute beia_trb (cost=0.42..4.22 rows=1 width=12) (actual time=0.065..0.065 rows=0 loops=1,000)

  • Output: beia_trb.bus_ent_inst_id, beia_trb.att_id, beia_trb.env_id, beia_trb.ent_inst_att_str_value, beia_trb.reg_date
  • Index Cond: ((beia_trb.bus_ent_inst_id = beia_prio.bus_ent_inst_id) AND (beia_trb.att_id = 4,016) AND (beia_trb.env_id = 1,001) AND (beia_trb.ent_inst_att_str_value = 'Noticia Nueva'::text))
  • Heap Fetches: 0
  • Buffers: shared hit=2,983 read=19
Planning time : 4.875 ms
Execution time : 7,960.396 ms