explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j2QGp : 234

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

Limit (cost=0.43..405.94 rows=100 width=2,204) (actual time=0.031..0.031 rows=0 loops=1)

2. 0.029 0.029 ↓ 0.0 0 1

Index Scan Backward using uzgps_notification_y2019m01_n_mobject_id_n_event_type_n_val_idx on uzgps_notification_y2019m01 (cost=0.43..462.71 rows=114 width=2,204) (actual time=0.029..0.029 rows=0 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_event_type = 1))