explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dUO5 : 123123

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 29.242 ↓ 0.0 0 1

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

2. 29.240 29.240 ↓ 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=29.240..29.240 rows=0 loops=1)

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