explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cZin

Settings
# exclusive inclusive rows x rows loops node
1. 13.402 353,527.442 ↑ 1.3 7,706 1

Sort (cost=167,431.93..167,457.78 rows=10,339 width=32) (actual time=353,523.879..353,527.442 rows=7,706 loops=1)

  • Sort Key: txn.commit_time_ms, txn.id
  • Sort Method: quicksort Memory: 795kB
2. 34.944 353,514.040 ↑ 1.3 7,706 1

GroupAggregate (cost=166,461.15..166,742.53 rows=10,339 width=32) (actual time=353,461.682..353,514.040 rows=7,706 loops=1)

  • Group Key: txn.id
3. 725.341 353,479.096 ↓ 1.2 13,820 1

Sort (cost=166,461.15..166,490.82 rows=11,866 width=24) (actual time=353,461.627..353,479.096 rows=13,820 loops=1)

  • Sort Key: txn.id
  • Sort Method: quicksort Memory: 1464kB
4. 12.213 352,753.755 ↓ 1.2 13,820 1

Nested Loop (cost=1.12..165,658.15 rows=11,866 width=24) (actual time=0.061..352,753.755 rows=13,820 loops=1)

5. 442.762 442.762 ↓ 1.4 14,324 1

Index Only Scan using idx_alf_txn_ctms on alf_transaction txn (cost=0.56..4,031.57 rows=10,339 width=16) (actual time=0.036..442.762 rows=14,324 loops=1)

  • Index Cond: ((commit_time_ms >= '1546918830006'::bigint) AND (commit_time_ms < '1546922430006'::bigint))
  • Heap Fetches: 14395
6. 352,298.780 352,298.780 ↑ 80.0 1 14,324

Index Only Scan using idx_alf_node_txn_type on alf_node node (cost=0.56..14.83 rows=80 width=16) (actual time=0.015..24.595 rows=1 loops=14,324)

  • Index Cond: (transaction_id = txn.id)
  • Heap Fetches: 13875