explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MUYi

Settings
# exclusive inclusive rows x rows loops node
1. 2.029 2.115 ↑ 1.0 1 1

Update on payloads (cost=6.54..14.57 rows=1 width=80) (actual time=2.113..2.115 rows=1 loops=1)

  • Buffers: shared hit=36 read=7
  • I/O Timings: read=0.211
2. 0.006 0.086 ↑ 1.0 1 1

Nested Loop (cost=6.54..14.57 rows=1 width=80) (actual time=0.085..0.086 rows=1 loops=1)

  • Buffers: shared hit=6
3. 0.023 0.069 ↑ 1.0 1 1

HashAggregate (cost=6.26..6.27 rows=1 width=40) (actual time=0.068..0.069 rows=1 loops=1)

  • Group Key: "ANY_subquery".id
  • Buffers: shared hit=3
4. 0.019 0.046 ↑ 1.0 1 1

Subquery Scan on ANY_subquery (cost=0.14..6.25 rows=1 width=40) (actual time=0.045..0.046 rows=1 loops=1)

  • Buffers: shared hit=3
5. 0.002 0.027 ↑ 1.0 1 1

Limit (cost=0.14..6.24 rows=1 width=22) (actual time=0.026..0.027 rows=1 loops=1)

  • Buffers: shared hit=3
6. 0.018 0.025 ↑ 1.0 1 1

LockRows (cost=0.14..6.24 rows=1 width=22) (actual time=0.025..0.025 rows=1 loops=1)

  • Buffers: shared hit=3
7. 0.007 0.007 ↑ 1.0 1 1

Index Scan using active_modified_at_idx on payloads payloads_1 (cost=0.14..6.23 rows=1 width=22) (actual time=0.007..0.007 rows=1 loops=1)

  • Filter: (state = 'enqueued'::state_t)
  • Buffers: shared hit=2
8. 0.011 0.011 ↑ 1.0 1 1

Index Scan using payloads_pkey on payloads (cost=0.29..8.30 rows=1 width=44) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (id = "ANY_subquery".id)
  • Buffers: shared hit=3
Planning time : 0.246 ms
Execution time : 2.197 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
payloads_modified 0.375 ms 1 0.375 ms