explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YFjB

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

Limit (cost=8.17..8.19 rows=1 width=2,086) (actual time=0.033..0.033 rows=0 loops=1)

2. 0.000 0.032 ↓ 0.0 0 1

LockRows (cost=8.17..8.19 rows=1 width=2,086) (actual time=0.032..0.032 rows=0 loops=1)

3. 0.020 0.032 ↓ 0.0 0 1

Sort (cost=8.17..8.18 rows=1 width=2,086) (actual time=0.032..0.032 rows=0 loops=1)

  • Sort Key: priority, created_at
  • Sort Method: quicksort Memory: 25kB
4. 0.012 0.012 ↓ 0.0 0 1

Index Scan using idx_netreq_host on net_requests (cost=0.14..8.16 rows=1 width=2,086) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (net_host_id = 35)
  • Filter: ((monitor_process_id IS NULL) AND (((status)::text = 'net_waiting'::text) OR (((status)::text = 'net_retrying'::text) AND (retry_at <= '2020-03-18 02:02:36.275007'::timestamp without time zone))))