explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UBox

Settings
# exclusive inclusive rows x rows loops node
1. 172.176 1,661.737 ↑ 1.2 19,292 1

Sort (cost=32,387.32..32,443.35 rows=22,415 width=32) (actual time=1,606.615..1,661.737 rows=19,292 loops=1)

  • Sort Key: txn.commit_time_ms, txn.id
  • Sort Method: quicksort Memory: 2276kB
2. 151.966 1,489.561 ↑ 1.2 19,292 1

Finalize HashAggregate (cost=30,543.44..30,767.59 rows=22,415 width=32) (actual time=1,452.223..1,489.561 rows=19,292 loops=1)

  • Group Key: txn.id
3. 125.327 1,337.595 ↓ 1.1 19,292 1

Gather (cost=28,429.26..30,408.49 rows=17,993 width=32) (actual time=1,261.958..1,337.595 rows=19,292 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 142.643 1,212.268 ↑ 1.9 9,646 2

Partial HashAggregate (cost=27,429.26..27,609.19 rows=17,993 width=32) (actual time=1,209.316..1,212.268 rows=9,646 loops=2)

  • Group Key: txn.id
5. 935.393 1,069.625 ↑ 1.1 16,076 2

Nested Loop (cost=0.85..27,204.35 rows=17,993 width=24) (actual time=0.375..1,069.625 rows=16,076 loops=2)

6. 134.156 134.156 ↑ 1.2 11,413 2

Parallel Index Only Scan using idx_alf_txn_ctms on alf_transaction txn (cost=0.43..4,909.43 rows=13,185 width=16) (actual time=0.042..134.156 rows=11,413 loops=2)

  • Index Cond: ((commit_time_ms >= '1574860470007'::bigint) AND (commit_time_ms < '1574864070007'::bigint))
  • Heap Fetches: 25722
7. 0.076 0.076 ↑ 2.0 1 22,826

Index Only Scan using idx_alf_node_txn_type on alf_node node (cost=0.43..1.67 rows=2 width=16) (actual time=0.070..0.076 rows=1 loops=22,826)

  • Index Cond: (transaction_id = txn.id)
  • Heap Fetches: 35069
Planning time : 0.460 ms
Execution time : 1,663.796 ms