explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b7TS : 123123

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 25.805 ↓ 0.0 0 1

Limit (cost=0.56..70,419.22 rows=100 width=2,204) (actual time=25.805..25.805 rows=0 loops=1)

2. 25.805 25.805 ↓ 0.0 0 1

Index Scan Backward using uzgps_notification_temp_y2018m12_n_mobject_id_n_value_time_idx on uzgps_notification_y2018m12 (cost=0.56..315,476.14 rows=448 width=2,204) (actual time=25.805..25.805 rows=0 loops=1)

  • Index Cond: (n_mobject_id = 1060)
  • Filter: (n_event_type = 1)
  • Rows Removed by Filter: 12552