explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rKBW

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 38,482.607 ↑ 140.0 1 1

HashAggregate (cost=403,608.02..403,609.42 rows=140 width=524) (actual time=38,482.606..38,482.607 rows=1 loops=1)

  • Group Key: p.payment_type_id
  • Buffers: shared hit=56,506 read=136,494 written=10,420
2.          

Initplan (for HashAggregate)

3. 0.000 0.000 ↓ 0.0 0

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

  • Filter: ((name)::text = 'Unknown'::text)
4. 1,792.704 38,482.589 ↑ 1,200,501.8 5 1

Hash Join (cost=13.59..388,589.99 rows=6,002,509 width=520) (actual time=6,478.034..38,482.589 rows=5 loops=1)

  • Hash Cond: ((e.payment_type)::text = (p.name)::text)
  • Buffers: shared hit=56,506 read=136,494 written=10,420
5. 36,689.415 36,689.415 ↑ 1.0 5,923,372 1

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

  • Index Cond: (etl_batch_file_id = 444)
  • Buffers: shared hit=56,506 read=136,493 written=10,420
6. 0.014 0.470 ↑ 5.4 26 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared read=1
7. 0.456 0.456 ↑ 5.4 26 1

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

  • Buffers: shared read=1