explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pnUJ : 123

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.023 ↓ 0.0 0 1

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

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

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