explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lsi1

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 44,519.361 ↑ 140.0 1 1

HashAggregate (cost=403,608.02..403,609.42 rows=140 width=524) (actual time=44,519.360..44,519.361 rows=1 loops=1)

  • Output: COALESCE(p.payment_type_id, $0), p.name, p.payment_type_id
  • Group Key: p.payment_type_id
  • Buffers: shared hit=56506 read=136494 written=13883
2.          

Initplan (for HashAggregate)

3. 0.000 0.000 ↓ 0.0 0

Seq Scan on scv.lkup_payment_types (cost=0.00..11.75 rows=1 width=4) (never executed)

  • Output: lkup_payment_types.payment_type_id
  • Filter: ((lkup_payment_types.name)::text = 'Unknown'::text)
4. 1,848.068 44,519.325 ↑ 1,200,501.8 5 1

Hash Join (cost=13.59..388,589.99 rows=6,002,509 width=520) (actual time=6,588.815..44,519.325 rows=5 loops=1)

  • Output: p.payment_type_id, p.name
  • Hash Cond: ((e.payment_type)::text = (p.name)::text)
  • Buffers: shared hit=56506 read=136494 written=13883
5. 42,670.702 42,670.702 ↑ 1.0 5,923,372 1

Index Scan using "index_etl.payments_on_etl_batch_file_id" on etl.payments e (cost=0.44..306,042.35 rows=6,002,509 width=21) (actual time=2.068..42,670.702 rows=5,923,372 loops=1)

  • Output: e.id, e.sale_id, e.ticketno, e.transaction_date, e.payment_type, e.payment_value, e.currency_type, e.card_type_code, e.card_description, e.entry_mode, e.etl_batch_file_id, e.imported, e.created_at, e.updated_at, e.customer_id
  • Index Cond: (e.etl_batch_file_id = 444)
  • Buffers: shared hit=56506 read=136493 written=13883
6. 0.012 0.555 ↑ 5.4 26 1

Hash (cost=11.40..11.40 rows=140 width=520) (actual time=0.555..0.555 rows=26 loops=1)

  • Output: p.payment_type_id, p.name
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared read=1
7. 0.543 0.543 ↑ 5.4 26 1

Seq Scan on scv.lkup_payment_types p (cost=0.00..11.40 rows=140 width=520) (actual time=0.538..0.543 rows=26 loops=1)

  • Output: p.payment_type_id, p.name
  • Buffers: shared read=1