explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jpim

Settings
# exclusive inclusive rows x rows loops node
1. 246.368 29,675.767 ↑ 118.1 30,548 1

Unique (cost=828,263..864,335.1 rows=3,607,210 width=13) (actual time=28,888.235..29,675.767 rows=30,548 loops=1)

  • Buffers: shared hit=428,479 read=186,461 dirtied=39, local hit=1 read=615 written=615, temp read=12,546 written=12,540
2. 3,160.104 29,429.399 ↑ 2.6 1,400,056 1

Sort (cost=828,263..837,281.02 rows=3,607,210 width=13) (actual time=28,888.233..29,429.399 rows=1,400,056 loops=1)

  • Sort Key: f.source, f.formula, pp.price
  • Sort Method: external merge Disk: 25,120kB
  • Buffers: shared hit=428,479 read=186,461 dirtied=39, local hit=1 read=615 written=615, temp read=12,546 written=12,540
3. 688.067 26,269.295 ↑ 2.6 1,400,056 1

Hash Join (cost=270,683.01..373,744.61 rows=3,607,210 width=13) (actual time=25,550.313..26,269.295 rows=1,400,056 loops=1)

  • Buffers: shared hit=428,479 read=186,461 dirtied=39, local hit=1 read=615 written=615, temp read=9,403 written=9,397
4. 31.655 31.655 ↑ 1.1 139,136 1

Seq Scan on t_roomrates t (cost=0..2,186.8 rows=157,080 width=4) (actual time=0.011..31.655 rows=139,136 loops=1)

  • Buffers: local hit=1 read=615 written=615
5. 494.057 25,549.573 ↑ 1.0 1,400,056 1

Hash (cost=244,978.31..244,978.31 rows=1,400,056 width=17) (actual time=25,549.573..25,549.573 rows=1,400,056 loops=1)

  • Buffers: shared hit=428,479 read=186,461 dirtied=39, temp read=4,767 written=9,088
6. 658.386 25,055.516 ↑ 1.0 1,400,056 1

Merge Join (cost=214,116.94..244,978.31 rows=1,400,056 width=17) (actual time=16,955.923..25,055.516 rows=1,400,056 loops=1)

  • Buffers: shared hit=428,479 read=186,461 dirtied=39, temp read=4,767 written=4,767
7. 20,501.818 20,501.818 ↑ 1.0 765,493 1

Index Scan using roomratesplanner_index_tips_4 on roomratesplanner pp (cost=0.43..254,704.44 rows=777,705 width=13) (actual time=0.09..20,501.818 rows=765,493 loops=1)

  • Index Cond: ((pp.day >= '2020-01-01'::date) AND (pp.day <= '2020-01-31'::date))
  • Buffers: shared hit=428,447 read=177,575 dirtied=39
8. 226.943 3,895.312 ↑ 1.0 1,400,056 1

Materialize (cost=200,273.57..207,273.85 rows=1,400,056 width=16) (actual time=3,009.055..3,895.312 rows=1,400,056 loops=1)

  • Buffers: shared hit=32 read=8,886, temp read=4,767 written=4,767
9. 3,058.508 3,668.369 ↑ 1.0 1,400,056 1

Sort (cost=200,273.57..203,773.71 rows=1,400,056 width=16) (actual time=3,009.05..3,668.369 rows=1,400,056 loops=1)

  • Sort Key: f.day, f.source
  • Sort Method: external merge Disk: 38,112kB
  • Buffers: shared hit=32 read=8,886, temp read=4,767 written=4,767
10. 609.861 609.861 ↑ 1.0 1,400,056 1

Seq Scan on q_f f (cost=0..33,418.98 rows=1,400,056 width=16) (actual time=0.02..609.861 rows=1,400,056 loops=1)

  • Filter: ((f.day >= '2020-01-01'::date) AND (f.day <= '2020-01-31'::date) AND (f.hotel = 14,054))
  • Buffers: shared hit=32 read=8,886
Planning time : 0.718 ms
Execution time : 29,687.447 ms