explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cc2x

Settings
# exclusive inclusive rows x rows loops node
1. 84.408 3,957.866 ↑ 1.2 19,292 1

Sort (cost=80,993.93..81,050.51 rows=22,634 width=32) (actual time=3,911.798..3,957.866 rows=19,292 loops=1)

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

Finalize HashAggregate (cost=79,130.45..79,356.79 rows=22,634 width=32) (actual time=3,819.973..3,873.458 rows=19,292 loops=1)

  • Group Key: txn.id
3. 125.718 3,796.265 ↑ 1.4 19,439 1

Gather (cost=76,173.72..78,933.33 rows=26,282 width=32) (actual time=3,698.115..3,796.265 rows=19,439 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 46.796 3,670.547 ↑ 2.0 6,480 3

Partial HashAggregate (cost=75,173.72..75,305.13 rows=13,141 width=32) (actual time=3,663.368..3,670.547 rows=6,480 loops=3)

  • Group Key: txn.id
5. 1,632.835 3,623.751 ↑ 1.2 10,717 3

Parallel Hash Join (cost=16,591.91..75,009.46 rows=13,141 width=24) (actual time=531.987..3,623.751 rows=10,717 loops=3)

  • Hash Cond: (node.transaction_id = txn.id)
6. 1,832.615 1,832.615 ↑ 1.2 628,788 3

Parallel Seq Scan on alf_node node (cost=0.00..56,367.33 rows=781,033 width=16) (actual time=0.155..1,832.615 rows=628,788 loops=3)

7. 52.726 158.301 ↑ 1.7 7,609 3

Parallel Hash (cost=16,425.48..16,425.48 rows=13,314 width=16) (actual time=158.301..158.301 rows=7,609 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1376kB
8. 105.575 105.575 ↑ 1.7 7,609 3

Parallel Index Only Scan using idx_alf_txn_ctms on alf_transaction txn (cost=0.43..16,425.48 rows=13,314 width=16) (actual time=0.059..105.575 rows=7,609 loops=3)

  • Index Cond: ((commit_time_ms >= '1574860470007'::bigint) AND (commit_time_ms < '1574864070007'::bigint))
  • Heap Fetches: 25722
Planning time : 1.329 ms
Execution time : 3,960.430 ms