explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ntd3

Settings
# exclusive inclusive rows x rows loops node
1. 13,908.869 13,969.523 ↓ 0.0 0 1

Update on transactions (cost=38,724.92..39,531.41 rows=10,000 width=432) (actual time=13,969.523..13,969.523 rows=0 loops=1)

2. 23.295 60.654 ↑ 1.0 10,000 1

Nested Loop (cost=38,724.92..39,531.41 rows=10,000 width=432) (actual time=11.563..60.654 rows=10,000 loops=1)

3. 7.914 17.359 ↓ 50.0 10,000 1

HashAggregate (cost=38,724.91..38,726.91 rows=200 width=36) (actual time=11.554..17.359 rows=10,000 loops=1)

  • Group Key: "ANY_subquery".ctid
4. 1.478 9.445 ↑ 1.0 10,000 1

Subquery Scan on ANY_subquery (cost=0.56..38,699.91 rows=10,000 width=36) (actual time=1.783..9.445 rows=10,000 loops=1)

5. 0.782 7.967 ↑ 1.0 10,000 1

Limit (cost=0.56..38,599.91 rows=10,000 width=6) (actual time=1.780..7.967 rows=10,000 loops=1)

6. 7.185 7.185 ↑ 24.6 10,000 1

Index Scan using transactions_merchant_checked_at_index on transactions transactions_1 (cost=0.56..947,626.14 rows=245,503 width=6) (actual time=1.780..7.185 rows=10,000 loops=1)

  • Index Cond: (merchant_checked_at IS NULL)
  • Filter: (inserted_at < (now() - '01:00:00'::interval))
7. 20.000 20.000 ↑ 1.0 1 10,000

Tid Scan on transactions (cost=0.00..4.01 rows=1 width=390) (actual time=0.002..0.002 rows=1 loops=10,000)

  • TID Cond: (ctid = "ANY_subquery".ctid)
Planning time : 1.566 ms
Execution time : 13,969.668 ms