explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ynoa

Settings
# exclusive inclusive rows x rows loops node
1. 14,196.910 77,240.484 ↓ 0.0 0 1

ModifyTable (cost=32,497.4..271,769.48 rows=10,804,134 width=64) (actual time=77,240.484..77,240.484 rows=0 loops=1)

  • Buffers: shared hit=3 read=22443 written=7, local hit=21825397 read=207973 dirtied=207972 written=207973
2. 57,060.960 63,043.574 ↑ 1.0 10,803,686 1

Hash Join (cost=32,497.4..271,769.48 rows=10,804,134 width=64) (actual time=560.052..63,043.574 rows=10,803,686 loops=1)

  • Buffers: shared hit=3 read=22443 written=7, local read=98818 dirtied=8818 written=98818
3. 5,423.306 5,423.306 ↓ 1.0 10,804,975 1

Seq Scan on tmp_fact_claim_product_location tmp_fact_claim_product_location (cost=0..206,859.34 rows=10,804,134 width=54) (actual time=0.052..5,423.306 rows=10,804,975 loops=1)

  • Buffers: local read=98818 dirtied=8818 written=98818
4. 206.803 559.308 ↑ 1.0 446,862 1

Hash (cost=26,911.62..26,911.62 rows=446,862 width=47) (actual time=559.307..559.308 rows=446,862 loops=1)

  • Buffers: shared read=22443 written=7
5. 352.505 352.505 ↑ 1.0 446,862 1

Seq Scan on dim_location dl (cost=0..26,911.62 rows=446,862 width=47) (actual time=0.04..352.505 rows=446,862 loops=1)

  • Buffers: shared read=22443 written=7