explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TCkh

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 1,403.466 ↑ 1.0 15 1

Limit (cost=53,179.82..53,181.55 rows=15 width=456) (actual time=1,403.458..1,403.466 rows=15 loops=1)

  • Buffers: shared hit=2,528 read=8,705, temp read=17,332 written=18,723
2. 261.017 1,630.890 ↑ 4,776.3 15 1

Gather Merge (cost=53,179.82..61,419 rows=71,645 width=456) (actual time=1,403.457..1,630.89 rows=15 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=5,140 read=14,764, temp read=33,720 written=33,992
3. 68.939 1,369.873 ↑ 5,511.2 13 2 / 2

Sort (cost=52,179.81..52,358.92 rows=71,645 width=456) (actual time=1,369.872..1,369.873 rows=13 loops=2)

  • Sort Key: t179.index_179, t325.id_325
  • Sort Method: top-N heapsort Memory: 28kB
  • Buffers: shared hit=5,140 read=14,764, temp read=33,720 written=33,992
4. 46.886 1,300.934 ↓ 1.9 133,480 2 / 2

Hash Join (cost=39,610.01..50,422.04 rows=71,645 width=456) (actual time=1,053.221..1,300.934 rows=133,480 loops=2)

  • Buffers: shared hit=5,122 read=14,764, temp read=33,720 written=33,992
5. 30.927 1,253.752 ↓ 1.9 133,480 2 / 2

Hash Join (cost=39,599.91..49,441.15 rows=71,645 width=162) (actual time=1,052.916..1,253.752 rows=133,480 loops=2)

  • Buffers: shared hit=5,110 read=14,764, temp read=33,720 written=33,992
6. 32.507 1,222.803 ↓ 2.2 133,480 2 / 2

Hash Join (cost=39,592.05..49,030.64 rows=61,213 width=162) (actual time=1,052.888..1,222.803 rows=133,480 loops=2)

  • Buffers: shared hit=5,104 read=14,764, temp read=33,720 written=33,992
7. 27.541 1,190.143 ↓ 2.6 133,480 2 / 2

Hash Join (cost=39,584.19..48,678.74 rows=52,300 width=158) (actual time=1,052.731..1,190.143 rows=133,480 loops=2)

  • Buffers: shared hit=5,098 read=14,764, temp read=33,720 written=33,992
8. 28.176 1,162.226 ↓ 2.6 133,480 2 / 2

Hash Join (cost=39,542.33..48,361.96 rows=52,300 width=158) (actual time=1,052.349..1,162.226 rows=133,480 loops=2)

  • Buffers: shared hit=5,080 read=14,764, temp read=33,720 written=33,992
9. 128.735 1,134.029 ↓ 2.6 133,480 2 / 2

Hash Join (cost=39,539.98..48,076.72 rows=52,300 width=155) (actual time=1,052.316..1,134.029 rows=133,480 loops=2)

  • Buffers: shared hit=5,078 read=14,764, temp read=33,720 written=33,992
10. 26.758 26.758 ↑ 1.2 133,480 2 / 2

Seq Scan on price_list_pos_version_subaru_336 t336 (cost=0..4,857.94 rows=157,035 width=32) (actual time=0.181..26.758 rows=133,480 loops=2)

  • Filter: (t336.id_115_336 = 1,100)
  • Buffers: shared hit=2 read=2,893
11. 122.083 978.536 ↓ 3.6 133,480 2 / 2

Hash (cost=38,352.83..38,352.83 rows=37,052 width=135) (actual time=978.536..978.536 rows=133,480 loops=2)

  • Buffers: shared hit=5,032 read=11,871, temp read=27,826 written=32,256
12. 19.503 856.453 ↓ 3.6 133,480 2 / 2

Hash Join (cost=31,961.33..38,352.83 rows=37,052 width=135) (actual time=741.987..856.453 rows=133,480 loops=2)

  • Buffers: shared hit=5,032 read=11,871, temp read=23,272 written=23,412
13. 24.465 836.944 ↓ 3.6 133,480 2 / 2

Hash Join (cost=31,938.39..38,051.99 rows=37,052 width=130) (actual time=741.975..836.944 rows=133,480 loops=2)

  • Buffers: shared hit=5,030 read=11,871, temp read=23,272 written=23,412
14. 105.759 812.300 ↓ 3.6 133,480 2 / 2

Hash Join (cost=31,936.04..37,845.96 rows=37,052 width=127) (actual time=741.786..812.3 rows=133,480 loops=2)

  • Buffers: shared hit=5,028 read=11,871, temp read=23,272 written=23,412
15. 23.039 23.039 ↓ 1.2 133,480 2 / 2

Seq Scan on producer_assortment_subaru_188 t188 (cost=0..5,338.42 rows=111,233 width=68) (actual time=0.205..23.039 rows=133,480 loops=2)

  • Filter: (t188.id_115_188 = 1,100)
  • Buffers: shared hit=2 read=3,946
16. 63.951 683.502 ↓ 3.6 133,480 2 / 2

Hash (cost=31,472.89..31,472.89 rows=37,052 width=75) (actual time=683.502..683.502 rows=133,480 loops=2)

  • Buffers: shared hit=5,026 read=7,925, temp read=17,358 written=20,392
17. 95.940 619.551 ↓ 3.6 133,480 2 / 2

Hash Join (cost=26,020.29..31,472.89 rows=37,052 width=75) (actual time=559.596..619.551 rows=133,480 loops=2)

  • Buffers: shared hit=5,026 read=7,925, temp read=16,011 written=16,104
18. 21.213 21.213 ↓ 1.2 133,555 2 / 2

Seq Scan on assortment_interface_179 t179 (cost=0..4,817.2 rows=111,296 width=40) (actual time=0.172..21.213 rows=133,555 loops=2)

  • Filter: (t179.id_115_179 = 1,100)
  • Buffers: shared hit=2 read=3,424
19. 59.242 502.398 ↓ 2.6 133,480 2 / 2

Hash (cost=25,366.18..25,366.18 rows=52,329 width=47) (actual time=502.398..502.398 rows=133,480 loops=2)

  • Buffers: shared hit=5,024 read=4,501, temp read=10,877 written=13,008
20. 79.892 443.156 ↓ 2.6 133,480 2 / 2

Hash Join (cost=20,496.54..25,366.18 rows=52,329 width=47) (actual time=392.86..443.156 rows=133,480 loops=2)

  • Buffers: shared hit=5,024 read=4,501, temp read=9,935 written=9,980
21. 15.650 15.650 ↑ 1.2 133,480 2 / 2

Seq Scan on producer_assortment_182 t182 (cost=0..3,972.94 rows=157,035 width=15) (actual time=0.175..15.65 rows=133,480 loops=2)

  • Filter: (t182.id_115_182 = 1,100)
  • Buffers: shared hit=3 read=2,007
22. 102.157 347.614 ↓ 2.6 133,480 2 / 2

Hash (cost=19,842.31..19,842.31 rows=52,338 width=32) (actual time=347.614..347.614 rows=133,480 loops=2)

  • Buffers: shared hit=5,021 read=2,494, temp read=6,783 written=8,324
23. 116.267 245.457 ↓ 2.6 133,480 2 / 2

Hash Join (cost=11,648.15..19,842.31 rows=52,338 width=32) (actual time=107.186..245.457 rows=133,480 loops=2)

  • Buffers: shared hit=5,021 read=2,494, temp read=5,572 written=5,572
24. 23.355 23.355 ↑ 1.2 133,480 2 / 2

Seq Scan on price_list_pos_325 t325 (cost=0..4,851.9 rows=157,034 width=16) (actual time=0.168..23.355 rows=133,480 loops=2)

  • Filter: ((t325.id_115_325 = 1,100) AND (t325.id_324_325 = 14))
  • Buffers: shared hit=2 read=2,494
25. 52.213 105.835 ↓ 3.0 267,002 2 / 2

Hash (cost=9,839.79..9,839.79 rows=88,989 width=36) (actual time=105.835..105.835 rows=267,002 loops=2)

  • Buffers: shared hit=4,994, temp written=3,246
26. 31.822 53.622 ↓ 3.0 267,002 2 / 2

Nested Loop (cost=0..9,839.79 rows=88,989 width=36) (actual time=0.476..53.622 rows=267,002 loops=2)

  • Buffers: shared hit=4,994
27. 0.002 0.320 ↑ 1.0 1 2 / 2

Nested Loop (cost=0..2.24 rows=1 width=16) (actual time=0.319..0.32 rows=1 loops=2)

  • Buffers: shared hit=4
28. 0.157 0.157 ↑ 1.0 1 2 / 2

Seq Scan on price_list_324 t324 (cost=0..1.1 rows=1 width=8) (actual time=0.157..0.157 rows=1 loops=2)

  • Filter: ((t324.id_115_324 = 1,100) AND (t324.id_324 = 14))
  • Buffers: shared hit=2
29. 0.161 0.161 ↑ 1.0 1 2 / 2

Seq Scan on price_list_pos_version_seq_335 t335 (cost=0..1.12 rows=1 width=12) (actual time=0.161..0.161 rows=1 loops=2)

  • Filter: ((t335.id_115_335 = 1,100) AND (t335.id_324_335 = 14) AND (t335.version_335 = 1))
  • Buffers: shared hit=2
30. 21.480 21.480 ↑ 1.0 267,002 2 / 2

Seq Scan on price_list_pos_version_334 t334 (cost=0..5,832.52 rows=267,002 width=28) (actual time=0.155..21.48 rows=267,002 loops=2)

  • Filter: (t334.id_115_334 = 1,100)
  • Buffers: shared hit=4,990
31. 0.007 0.179 ↑ 1.0 49 2 / 2

Hash (cost=1.61..1.61 rows=49 width=11) (actual time=0.179..0.179 rows=49 loops=2)

  • Buffers: shared hit=2
32. 0.172 0.172 ↑ 1.0 49 2 / 2

Seq Scan on discount_group_376 t376 (cost=0..1.61 rows=49 width=11) (actual time=0.168..0.172 rows=49 loops=2)

  • Filter: (t376.id_115_376 = 1,100)
  • Buffers: shared hit=2
33. 0.000 0.006 ↓ 0.0 0 2 / 2

Hash (cost=22.85..22.85 rows=6 width=13) (actual time=0.006..0.006 rows=0 loops=2)

  • Buffers: shared hit=2
34. 0.001 0.006 ↓ 0.0 0 2 / 2

Bitmap Heap Scan on price_list_pos_deliverer_326 t326 (cost=13.38..22.85 rows=6 width=13) (actual time=0.006..0.006 rows=0 loops=2)

  • Buffers: shared hit=2
35. 0.005 0.005 ↓ 0.0 0 2 / 2

Bitmap Index Scan on pk_326 (cost=0..13.38 rows=6 width=0) (actual time=0.005..0.005 rows=0 loops=2)

  • Index Cond: (t326.id_115_326 = 1,100)
  • Buffers: shared hit=2
36. 0.007 0.021 ↑ 1.0 49 2 / 2

Hash (cost=1.61..1.61 rows=49 width=11) (actual time=0.021..0.021 rows=49 loops=2)

  • Buffers: shared hit=2
37. 0.014 0.014 ↑ 1.0 49 2 / 2

Seq Scan on discount_group_376 t376j (cost=0..1.61 rows=49 width=11) (actual time=0.01..0.014 rows=49 loops=2)

  • Filter: (t376j.id_115_376 = 1,100)
  • Buffers: shared hit=2
38. 0.112 0.376 ↑ 1.0 1,195 2 / 2

Hash (cost=23.94..23.94 rows=1,195 width=12) (actual time=0.376..0.376 rows=1,195 loops=2)

  • Buffers: shared hit=18
39. 0.264 0.264 ↑ 1.0 1,195 2 / 2

Seq Scan on article_group_rate_subaru_378 t378j (cost=0..23.94 rows=1,195 width=12) (actual time=0.144..0.264 rows=1,195 loops=2)

  • Filter: (t378j.id_115_378 = 1,100)
  • Buffers: shared hit=18
40. 0.003 0.153 ↓ 1.1 14 2 / 2

Hash (cost=7.67..7.67 rows=13 width=12) (actual time=0.153..0.153 rows=14 loops=2)

  • Buffers: shared hit=6
41. 0.150 0.150 ↓ 1.1 14 2 / 2

Seq Scan on vat_trans_106 t106a (cost=0..7.67 rows=13 width=12) (actual time=0.134..0.15 rows=14 loops=2)

  • Filter: ((t106a.id_115_106_106 = 1,100) AND (t106a.id_000_106 = 1))
  • Buffers: shared hit=6
42. 0.003 0.022 ↓ 1.1 14 2 / 2

Hash (cost=7.67..7.67 rows=13 width=12) (actual time=0.022..0.022 rows=14 loops=2)

  • Buffers: shared hit=6
43. 0.019 0.019 ↓ 1.1 14 2 / 2

Seq Scan on vat_trans_106 t106b (cost=0..7.67 rows=13 width=12) (actual time=0.005..0.019 rows=14 loops=2)

  • Filter: ((t106b.id_115_106_106 = 1,100) AND (t106b.id_000_106 = 1))
  • Buffers: shared hit=6
44. 0.004 0.296 ↑ 1.0 21 2 / 2

Hash (cost=9.78..9.78 rows=21 width=33) (actual time=0.296..0.296 rows=21 loops=2)

  • Buffers: shared hit=12
45. 0.021 0.292 ↑ 1.0 21 2 / 2

Hash Join (cost=3.64..9.78 rows=21 width=33) (actual time=0.278..0.292 rows=21 loops=2)

  • Buffers: shared hit=12
46. 0.134 0.134 ↑ 1.0 51 2 / 2

Seq Scan on customer_data_621 t621 (cost=0..5.69 rows=51 width=15) (actual time=0.128..0.134 rows=51 loops=2)

  • Filter: (t621.id_115_621 = 1,100)
  • Buffers: shared hit=8
47. 0.004 0.137 ↑ 1.0 21 2 / 2

Hash (cost=3.33..3.33 rows=21 width=30) (actual time=0.137..0.137 rows=21 loops=2)

  • Buffers: shared hit=4
48. 0.133 0.133 ↑ 1.0 21 2 / 2

Seq Scan on customer_200 t200 (cost=0..3.33 rows=21 width=30) (actual time=0.129..0.133 rows=21 loops=2)

  • Filter: (t200.id_115_200 = 1,100)
  • Buffers: shared hit=4
Planning time : 17.655 ms
Execution time : 1,631.364 ms