explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PM4e

Settings
# exclusive inclusive rows x rows loops node
1. 1.381 164,548.483 ↑ 1.2 2,262 1

Sort (cost=68,706.07..68,713.09 rows=2,808 width=32) (actual time=164,548.097..164,548.483 rows=2,262 loops=1)

  • Sort Key: txn.commit_time_ms, txn.id
  • Sort Method: quicksort Memory: 273kB
2. 3.125 164,547.102 ↑ 1.2 2,262 1

GroupAggregate (cost=68,468.68..68,545.24 rows=2,808 width=32) (actual time=164,543.291..164,547.102 rows=2,262 loops=1)

  • Group Key: txn.id
3. 2.981 164,543.977 ↓ 1.5 4,688 1

Sort (cost=68,468.68..68,476.76 rows=3,232 width=24) (actual time=164,543.265..164,543.977 rows=4,688 loops=1)

  • Sort Key: txn.id
  • Sort Method: quicksort Memory: 559kB
4. 4.645 164,540.996 ↓ 1.5 4,688 1

Nested Loop (cost=1.12..68,280.28 rows=3,232 width=24) (actual time=0.070..164,540.996 rows=4,688 loops=1)

5. 39.671 39.671 ↓ 1.4 4,040 1

Index Only Scan using idx_alf_txn_ctms on alf_transaction txn (cost=0.56..186.64 rows=2,808 width=16) (actual time=0.045..39.671 rows=4,040 loops=1)

  • Index Cond: ((commit_time_ms >= '1546885080003'::bigint) AND (commit_time_ms < '1546888680003'::bigint))
  • Heap Fetches: 4310
6. 164,496.680 164,496.680 ↑ 79.0 1 4,040

Index Only Scan using idx_alf_node_txn_type on alf_node node (cost=0.56..23.46 rows=79 width=16) (actual time=0.006..40.717 rows=1 loops=4,040)

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