explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GG3l

Settings
# exclusive inclusive rows x rows loops node
1. 116.346 23,313.711 ↓ 2.0 2 1

Gather (cost=266,188.56..1,144,167.53 rows=1 width=1,096) (actual time=21,573.374..23,313.711 rows=2 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 4,647.725 23,197.365 ↑ 1.0 1 3 / 3

Hash Left Join (cost=265,188.56..1,143,167.43 rows=1 width=1,096) (actual time=22,069.533..23,197.365 rows=1 loops=3)

  • Hash Cond: (ehi_transaction.txn_id = x19.txn_id)
  • Filter: (x19.id IS NULL)
  • Rows Removed by Filter: 1018802
3. 16,850.653 16,850.653 ↑ 1.2 1,018,803 3 / 3

Parallel Seq Scan on ehi_transaction (cost=0.00..518,180.01 rows=1,237,663 width=1,096) (actual time=0.243..16,850.653 rows=1,018,803 loops=3)

  • Filter: (NOT ignore)
  • Rows Removed by Filter: 4168
4. 510.305 1,698.987 ↑ 1.0 3,057,200 3 / 3

Hash (cost=208,395.58..208,395.58 rows=3,093,358 width=24) (actual time=1,698.987..1,698.987 rows=3,057,200 loops=3)

  • Buckets: 65536 Batches: 64 Memory Usage: 3127kB
5. 1,188.682 1,188.682 ↑ 1.0 3,057,200 3 / 3

Seq Scan on transaction x19 (cost=0.00..208,395.58 rows=3,093,358 width=24) (actual time=0.020..1,188.682 rows=3,057,200 loops=3)

Planning time : 0.235 ms
Execution time : 23,313.778 ms