explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c1d9

Settings
# exclusive inclusive rows x rows loops node
1. 2.855 137,341.815 ↑ 2.1 5,769 1

Sort (cost=157,457.57..157,487.75 rows=12,069 width=32) (actual time=137,341.240..137,341.815 rows=5,769 loops=1)

  • Sort Key: txn.commit_time_ms, txn.id
  • Sort Method: quicksort Memory: 643kB
2. 8.762 137,338.960 ↑ 2.1 5,769 1

GroupAggregate (cost=156,311.54..156,639.35 rows=12,069 width=32) (actual time=137,328.457..137,338.960 rows=5,769 loops=1)

  • Group Key: txn.id
3. 264.564 137,330.198 ↑ 1.1 12,628 1

Sort (cost=156,311.54..156,346.06 rows=13,808 width=24) (actual time=137,328.407..137,330.198 rows=12,628 loops=1)

  • Sort Key: txn.id
  • Sort Method: quicksort Memory: 1371kB
4. 4.874 137,065.634 ↑ 1.1 12,628 1

Nested Loop (cost=1.12..155,362.02 rows=13,808 width=24) (actual time=0.096..137,065.634 rows=12,628 loops=1)

5. 47,825.610 47,825.610 ↓ 1.0 12,266 1

Index Only Scan using idx_alf_txn_ctms on alf_transaction txn (cost=0.56..3,646.13 rows=12,069 width=16) (actual time=0.064..47,825.610 rows=12,266 loops=1)

  • Index Cond: ((commit_time_ms >= '1546935970003'::bigint) AND (commit_time_ms < '1546939570003'::bigint))
  • Heap Fetches: 12895
6. 89,235.150 89,235.150 ↑ 82.0 1 12,266

Index Only Scan using idx_alf_node_txn_type on alf_node node (cost=0.56..11.75 rows=82 width=16) (actual time=1.975..7.275 rows=1 loops=12,266)

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