explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C1R

Settings
# exclusive inclusive rows x rows loops node
1. 898.074 2,011,776.180 ↑ 1.0 1 1

Aggregate (cost=1,284,519.13..1,284,519.14 rows=1 width=8) (actual time=2,011,776.179..2,011,776.180 rows=1 loops=1)

2. 448,649.777 2,010,878.106 ↑ 1.0 5,200,138 1

Hash Join (cost=514,927.73..1,271,476.52 rows=5,217,044 width=8) (actual time=1,069,878.894..2,010,878.106 rows=5,200,138 loops=1)

  • Hash Cond: (node.transaction_id = txn.id)
3. 506,692.028 506,692.028 ↑ 1.0 5,200,138 1

Seq Scan on alf_node node (cost=0.00..503,118.78 rows=5,217,044 width=8) (actual time=13.708..506,692.028 rows=5,200,138 loops=1)

  • Filter: (type_qname_id = '149'::bigint)
  • Rows Removed by Filter: 9540081
4. 333,106.903 1,055,536.301 ↓ 1.0 12,850,854 1

Hash (cost=291,787.88..291,787.88 rows=12,836,788 width=16) (actual time=1,055,536.300..1,055,536.301 rows=12,850,854 loops=1)

  • Buckets: 262144 Batches: 128 Memory Usage: 6773kB
5. 722,429.398 722,429.398 ↓ 1.0 12,850,854 1

Seq Scan on alf_transaction txn (cost=0.00..291,787.88 rows=12,836,788 width=16) (actual time=0.026..722,429.398 rows=12,850,854 loops=1)