explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nTRx

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

Limit (cost=4.18..4.20 rows=1 width=1,271) (actual time=0.131..0.131 rows=0 loops=1)

2. 0.000 0.130 ↓ 0.0 0 1

LockRows (cost=4.18..4.20 rows=1 width=1,271) (actual time=0.130..0.130 rows=0 loops=1)

3. 0.029 0.130 ↓ 0.0 0 1

Sort (cost=4.18..4.19 rows=1 width=1,271) (actual time=0.130..0.130 rows=0 loops=1)

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

Bitmap Heap Scan on net_requests (cost=3.05..4.17 rows=1 width=1,271) (actual time=0.101..0.101 rows=0 loops=1)

  • Recheck Cond: (((status)::text = 'net_waiting'::text) OR ((status)::text = 'net_retrying'::text))
  • Filter: ((monitor_process_id IS NULL) AND (net_host_id = 35) 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))))
  • Heap Blocks: exact=5
5. 0.002 0.075 ↓ 0.0 0 1

BitmapOr (cost=3.05..3.05 rows=1 width=0) (actual time=0.075..0.075 rows=0 loops=1)

6. 0.065 0.065 ↓ 6.0 6 1

Bitmap Index Scan on idx_netreq_status (cost=0.00..1.53 rows=1 width=0) (actual time=0.065..0.065 rows=6 loops=1)

  • Index Cond: ((status)::text = 'net_waiting'::text)
7. 0.008 0.008 ↓ 2.0 2 1

Bitmap Index Scan on idx_netreq_status (cost=0.00..1.53 rows=1 width=0) (actual time=0.008..0.008 rows=2 loops=1)

  • Index Cond: ((status)::text = 'net_retrying'::text)