explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SRd

Settings
# exclusive inclusive rows x rows loops node
1. 0.069 97.074 ↑ 1.0 1 1

Aggregate (cost=23.62..23.63 rows=1 width=0) (actual time=97.074..97.074 rows=1 loops=1)

2. 97.005 97.005 ↓ 2.5 111 1

Index Only Scan using ix_bus_ent_instance_log_namenum_entid on bus_ent_instance_log beil (cost=0.57..23.51 rows=44 width=0) (actual time=53.404..97.005 rows=111 loops=1)

  • Index Cond: ((bus_ent_inst_name_num = 5385) AND (bus_ent_id = 1006) AND (reg_status = 0))
  • Heap Fetches: 4
Planning time : 0.164 ms