explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o97f

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 39,069.209 ↓ 0.0 0 1

Sort (cost=517,143.67..517,143.68 rows=1 width=36) (actual time=39,069.209..39,069.209 rows=0 loops=1)

  • Sort Key: pdet.att_value_num_2
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=663884 read=18024 written=4
2. 0.006 39,069.172 ↓ 0.0 0 1

Nested Loop Anti Join (cost=1.85..517,143.66 rows=1 width=36) (actual time=39,069.172..39,069.172 rows=0 loops=1)

  • Join Filter: ((audiatt.env_id = pdet.env_id) AND (audi.env_id = pdet.env_id) AND ((audiatt.ent_inst_att_str_value)::text = (pdet.att_value_5)::text))
  • Buffers: shared hit=663881 read=18024 written=4
3. 14.239 39,069.166 ↓ 0.0 0 1

Nested Loop (cost=0.99..517,118.87 rows=1 width=54) (actual time=39,069.166..39,069.166 rows=0 loops=1)

  • Buffers: shared hit=663881 read=18024 written=4
4. 30,987.768 30,987.768 ↓ 3,847.0 3,847 1

Index Scan using ix_bus_ent_instance_05 on bus_ent_instance nc (cost=0.42..516,757.43 rows=1 width=14) (actual time=8.692..30,987.768 rows=3,847 loops=1)

  • Filter: (((att_value_9)::text = '47'::text) AND (att_value_num_2 = '5'::numeric))
  • Rows Removed by Filter: 665030
  • Buffers: shared hit=645911 read=8042 written=4
5. 8,067.159 8,067.159 ↓ 0.0 0 3,847

Index Scan using ix_bus_ent_instance_attn_01 on bus_ent_instance pdet (cost=0.57..361.44 rows=1 width=46) (actual time=2.097..2.097 rows=0 loops=3,847)

  • Index Cond: ((bus_ent_id = 1185) AND (att_value_num_1 = (nc.bus_ent_inst_name_num)::numeric) AND (env_id = 1001))
  • Filter: ((att_value_num_2 > '1568028202396'::numeric) AND ((att_value_3)::text = '4'::text))
  • Rows Removed by Filter: 6
  • Buffers: shared hit=17970 read=9982
6. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..12.81 rows=1 width=29) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_bus_ent_instance_attn_namenum_01 on bus_ent_instance audi (cost=0.57..8.59 rows=1 width=14) (never executed)

  • Index Cond: (((bus_ent_inst_name_pre)::text = 'SOLFORM'::text) AND (att_value_num_1 = (nc.bus_ent_inst_name_num)::numeric) AND (env_id = 1001))
  • Filter: (ent_sta_id <> 1070)
8. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix_bus_ent_inst_attribute_rep_sol_form_4546 on bus_ent_inst_attribute audiatt (cost=0.29..4.20 rows=2 width=23) (never executed)

  • Index Cond: ((bus_ent_inst_id = audi.bus_ent_inst_id_auto) AND (att_id = 4546) AND (env_id = 1001))
  • Heap Fetches: 0
Planning time : 15.384 ms
Execution time : 39,069.561 ms